We have a particular system where Text Importer is not working properly. PL/SQL Developer v7.1.4.1390.
This is confirmed to be working on a system w/v7.1.1.1339. Although, it may be a problem w/other unknown differences between the to PCs.
Client-side NLS_LANG = AMERICAN_AMERICA.WE8MSWIN1252.
Steps to reproduce :
PL/SQL Developer > Tools > Text Importer > Open Data File + Open Definition + Quote Character = single-quote.
Then, we do Import to Script.
On the v7.1.4.1390 client, the output is wrapping double-single-quotes around the character strings instead of a single-single-quote, as follows:
insert into table_name (column_list)
values (rtrim(''001-0237033-025''), ... and so on);
On the v7.1.1.1339 client, the sql statement is correct, as follows:
insert into table_name (column_list)
values (rtrim('001-0237033-025'), ... and so on);
Here is the relevant piece of our Definition file, for this first column:
[General]
ID=Import Definition
Version=1
Header=True
SingleLineRecord=True
QuoteChar="
TableOwner=SWB
OracleTable=DELL_RECEIVED_ASSETS
OverwriteDuplicates=True
CommitCount=100
EmptyTable=True
[ODBC]
DSN=
UserName=
Command=
Kind=0
[Fields]
Field=0
FieldStart=0
FieldStartValue=0
FieldEnd=2
FieldEndValue=
OracleSQL=rtrim('#')
OracleField=CONTRACT_NUM (VARCHAR2)
OracleType=0
ODBCField=
ODBCFieldNo=0
ODBCType=0
ODBCCType=0
ODBCLength=0
OracleParamNo=0
Here is the sample input record from the Data file:
001-0237033-025 ABC CORPORATION 9949 1/3/2003 OGGGG 450K G11/T NO NIC BASE W/512K
This is confirmed to be working on a system w/v7.1.1.1339. Although, it may be a problem w/other unknown differences between the to PCs.
Client-side NLS_LANG = AMERICAN_AMERICA.WE8MSWIN1252.
Steps to reproduce :
PL/SQL Developer > Tools > Text Importer > Open Data File + Open Definition + Quote Character = single-quote.
Then, we do Import to Script.
On the v7.1.4.1390 client, the output is wrapping double-single-quotes around the character strings instead of a single-single-quote, as follows:
insert into table_name (column_list)
values (rtrim(''001-0237033-025''), ... and so on);
On the v7.1.1.1339 client, the sql statement is correct, as follows:
insert into table_name (column_list)
values (rtrim('001-0237033-025'), ... and so on);
Here is the relevant piece of our Definition file, for this first column:
[General]
ID=Import Definition
Version=1
Header=True
SingleLineRecord=True
QuoteChar="
TableOwner=SWB
OracleTable=DELL_RECEIVED_ASSETS
OverwriteDuplicates=True
CommitCount=100
EmptyTable=True
[ODBC]
DSN=
UserName=
Command=
Kind=0
[Fields]
Field=0
FieldStart=0
FieldStartValue=0
FieldEnd=2
FieldEndValue=
OracleSQL=rtrim('#')
OracleField=CONTRACT_NUM (VARCHAR2)
OracleType=0
ODBCField=
ODBCFieldNo=0
ODBCType=0
ODBCCType=0
ODBCLength=0
OracleParamNo=0
Here is the sample input record from the Data file:
001-0237033-025 ABC CORPORATION 9949 1/3/2003 OGGGG 450K G11/T NO NIC BASE W/512K
