Re: pl2java: "DBMS_PACKAGE not installed?"
Date: 1997/01/26
Message-ID: <01bc0b96$91136aa0$5498b8cd_at_PHUBER.phuber.com>#1/1
Does the ID that you are trying the pl2java thing in have direct access on
the 'DBMS_PACKAGE.COUNT_PROCEDURE'
This message usually could be 1 of 2 things:
1- The object does not exist in your DB - you can verify this by 'select * from sys.dba_objects where object_name = 'DBMS_PACKAGE';' The status on the package should be 'VALID' .
2- The schema that you are trying to run the pl2java PL/SQL under does
not have access (direct) access to the package. - Try pulling the sql
statement that references the package out of the PL/SQL and execute it in
SQL.
i.e.'execute 'DBMS_PACKAGE.COUNT_PROCEDURE (..);' If this works
that means that the procedure within the package exists, and that you have
access to it, and that you have the synonym DBMS_PACKAGE set up. What it
probably is at this point is that you have access to the package via a
role. You cannot create a stored object accessing another if you only have
access to that object via a role. You can look at output from 'select *
from sys.dba_tab_privs where table_name = 'DBMS_PACKAGE';' to see which
'grantee' has direct access to execute this package.
Hope this helps
Peter Huber
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 Sun Jan 26 1997 - 00:00:00 CET