ODBC import problem

[ken ortiz]

Hello,
I'm trying to do an ODBC import into an oracle table from an excel spreadsheet. I have one field in the spreadsheet that needs to be mapped to a corresponding number field in the oracle table. String fields map fine, but when defining the fieldtype as number, the fieldtype does not stick after I leave it. Then when I import, that number field is not imported. Rest of the string data looks fine when I pull it up in oracle. Can anyone tell me what I'm doing wrong? Thanks.

 

[Marco Kalter]

Can you let me know if you are using the latest 7.0.3 version? There were some fieldmapping related issues in previous versions.

 

[ken ortiz]

Marco,
Version is 7.0.3.1123

 

[Marco Kalter]

Okay. Can you send me the Excel file and import definition file?

 

[krapas]

Hello,
I'm trying to do an ODBC import into an oracle table from MS SQL and I get
Message box:
"Error while importing Variable 35 not declared"

What this message mean?

 

[Marco Kalter]

I'm not sure what this means. To obtain some more diagnostic information, can you modify the shortcut and add the debugsql parameter? For example:

"C:\Program Files\PLSQL Developer\plsqldev.exe" debugsql

Reproduce the problem and send me the debug.txt file that is generated in the PL/SQL Developer directory.