Re: pl2java: "DBMS_PACKAGE not installed?"

There is a script to create the DBMS packages. It is called CATPROC.SQL and you must run it as SYS. This will ensure that the packages are created. You can check to see if there are any invalid packages in the view SYS.DBA_OBJECTS. If the package exists, the problem may be caused by a lack of privileges. The user who you connected as when you run the pl2jave script must be granted EXECUTE privileges on the necessary packages.

Dave

binghai_at_webworks.ca wrote in article <5cahuq$7nr$1_at_thor.atcon.com>...
> Hi,
>
> I am using WebServer 2.0 on a WindowsNT 4.0. Before I can use a PL/SQL
> prackage I have to run "pl2jave" to wrap up the package.When run this
> command, pl2java: gives me error like:
> PLS-00201: identifier 'DBMS_PACKAGE.COUNT_PROCEDURE' must be declared
> ORA-06550: line 1, column7:
> PL/SQL: Statement ignored
>
> pl2java: Make sure PL/SQL package DBMS_PACKAGE has been installed
> properly.
>
> I think I installed everything OK. Could some help me with this
> problem?
>
> Binghai Zeng
>
>
>
Received on Thu Jan 30 1997 - 00:00:00 CET