ORA-00604 error when compiling package

[BCBreid]

Oracle 9i - 9.2.0.2.0
PL/SQL Developer 5.0.3.527

Have just installed Oracle Designer 6i.
now when I try to compile packages in PL/SQL developer I get:

ORA-00604: error occurred at recursive SQL level 1
ORA-01460: unimplemented or unreasonable conversion requested

There are no conversions in code.
Compiled clean before install.
No problem browsing data or other objects (reference to earlier posts with similar error messages.)

Probably Oracle Designers fault but any help would be appreciated.

 

[Marco Kalter]

Perhaps you can start the Oracle Home Selector (a standard Oracle utility), change the Primary Oracle Home to your previous Oracle Home, and try again?

------------------
Marco Kalter
Allround Automations

 

[patch]

Designer 6i installs a rather buggy version of the Oracle Client (8.0.5 if I'm correct). Marco is right saying that you should set you're oracle home to the previous version.

------------------
Check out: http://www.oracledeveloper.nl

 

[BCBreid]

Thx all

Would appear reset of oracle home allows for clean use of pl/sql developer, Oracle forms 6i and designer 6i. Weird thing is that the stored procedure still gives same errors, but if I cut and paste code to a different stored procedure or a new one, no errors, no problems. Obviously some weird Oracle Database thing (Bad hair day, who knows) sent it on to Oracle let them figure it out, as I can move forward.

Thanks again