ORA - 03120 Two task conversion Routine

[Kalpesh]

I used to connect well with ORACLE but I had installed Oracle Reports (now deinstalled ) and I started getting this error in PLSQL developer while executing any query. First Error I got was

wrong NLS_LANG parameter... I have added the parameter (My computer > properties > Advanced ) and assigned value AMERICAN (others not working).

Now I am getting ORA-03120 two task conversion routine. After I click OK on the error there are two more errors displyed:

PLS-00553 Character set name not reconized
PL/SQL compilation unit analysis terminated

Please note that there are no changes to init.ora and I am able to connect and work normally thru Oracle PL/SQL prompt. (Not PLSQL developer prompt)

Any help is welcome as I am facing this since five days and I have reinstalled the package many times.

Kalpesh

 

[Bo Pedersen]

NLS_LANG shall have a value like AMERICAN_AMERICA.WE8ISO8859P1 with an appropriate character set.

Bo Pedersen

 

[azp74]

We had a problem with NLS_LANG - make sure you don't also have to change the value of this in the registry ... you don't mention Oracle version or platform (assuming some flavour of windows) - our problem was with 10g on an XP sp2 box.