Import tables via pde file - invalid number

[RamosIt]

Hi.
I have a problem importing data via PL/SQL Developer format (pde)
I get "ORA-01722: invalid number" and i suppose this is due to
number format.
Is there a way to force in importing session number format?

 

[Marco Kalter]

Do the source and destination PC's have a different NLS_LANG?

 

[RamosIt]

Source is
LANGUAGE ITALIAN
TERRITORY ITALY
CHARACTER SET WE8MSWIN1252

Destination is
LANGUAGE ITALIAN
TERRITORY ITALY
CHARACTER SET WE8ISO8859P15

 

[Marco Kalter]

That should be okay. Any difference in the NLS_NUMERIC_CHARACTERS value (if present)?

If not, can you check if the column data types of source and destination table are the same?

 

[RamosIt]

Sorry for delay..
No difference in NLS_NUMERIC_CHARACTERS that is both set as ".,"
Table columns have of course same data type..
Is there something other i can check or set when i do pde import?

 

[Marco Kalter]

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 or in the %APPDATA%\PLSQL Developer directory (e.g. C:\Users\\AppData\Roaming\PLSQL Developer).

 

[r2363c]

Hello,

does there's some improvement on that kind of issue in the next release ?
I've met it today, and it append often when source and destination are not the same server.

It's sad, because I like a lot the pl/sql dev import/export feature.
thanks,
Laurent