Import number problem

[nicofari]

Hello all,

I am using PL/SQL Developer 4.0.3.414
I am trying to import a PL/SQL Developer format export file.
I have a problem with a table containing a number(13,4) with decimal values.
Importing it gives

Error inserting record into M_VAL_REA:
ORA-01722: invalid number

It is possible that the source db and the target db doesn't have the same nls setup. I cannot verify the source db.
I think that source db has italian setup for decimal separator but I am not sure.
The target db has american
Is import sensitive to session nls parameters?
I tried to issue an
alter session set nls_numeric_characters=",."
and then re-importing (after forcing pl/sql in mono-session mode)
but the error is still here..
What else can I look for?

Thanks in advance
Bye
Nicola

 

[Marco Kalter]

What happens if you set the NLS_NUMERIC_CHARACTERS in the Oracle registry? This should fix any NLS issue. The alter session statement did not help, because each window uses its own session.