Re: DBMS_PACKAGE error. Pls help Thanks.

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Mon, 31 May 1999 19:05:48 +0200
Message-ID: <928170251.20437.0.pluto.d4ee154e@news.demon.nl>

Login using sqlplus as scott/tiger.
Then execute
select * from all_objects where object_name = 'DBMS_PACKAGE' Most likely this object is owned by SYS and 1 either it's invalid
2 or SYS didn't grant execute rigths to either SCOTT or PUBLIC 3 or a public synonym for this package doesn't exist.

Hth,

Sybrand Bakker, Oracle DBA

speedy wrote in message <375316C3.2B7F7AD9_at_pacific.net.sg>...
>hi,
>
>When l execute the following command, l've got the below mentioned
>error,
>Could u help me to rememdy this error
>
>$ pl2java scott/tiger_at_ora733 employee
>pl2java: ORA-06550: line 1, column 13:
>PLS-00201: identifier 'DBMS_PACKAGE.COUNT_PROCEDURES' must be declared
>ORA-06550: line 1, column 7:
>PL/SQL: Statement ignored
>
>pl2java: Make sure PL/SQL package DBMS_PACKAGE has been installed
>properly.
>
>with regards
>steven
>
>
>
Received on Mon May 31 1999 - 12:05:48 CDT