Error: component 'DBMS_SQL' must be declared
I'm running sqldeveloper rev 1.0.0.14.67 on Windows XP connecting to the Oracle database
"Oracle9i Enterprise Edition Release 9.2.0.5.0" on a Solaris box.
When I try to run or debug a database package I get the error message:
ORA-06550: line 3 column 11:
PLS-00302: component 'DBMS_SQL' must be declared.
An interesting thing is that this problem is occurring in one particular schema and not in others. The DBMS_SQL package is properly installed in the database and can be used from various tools such as SQLPlus, Java JDBC etc. when connected to the "troubling" schema.
Obviously something is not right with this particular schema but I'm not really sure what it can be.
The problem is not a matter of an old version of sqldeveloper as the issue exists in the version 1.2.1 of sqldeveloper which I also have installed on my PC.
Any ideas how to rectify this problem?
Many thanks!