Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

PLS-00302: component 'EXISTS' must be declared

471888Nov 25 2005 — edited Nov 25 2005
Hi,

I am finding the below given error while re-compiling a procedure.
Anybody can help me... Thanks in advance

SQL> ALTER PROCEDURE INVOICETAXSCHEDULE compile;

Warning: Procedure altered with compilation errors.

SQL> sho err
Errors for PROCEDURE INVOICETAXSCHEDULE:

LINE/COL ERROR
-------- -----------------------------------------------------------------
0/0 PLS-00904: insufficient privilege to access object SYS.PLITBLM
0/0 PLS-00904: insufficient privilege to access object SYS.PLITBLM
0/0 PLS-00904: insufficient privilege to access object SYS.PLITBLM
0/0 PLS-00904: insufficient privilege to access object SYS.PLITBLM
0/0 PLS-00904: insufficient privilege to access object SYS.PLITBLM
0/0 PLS-00904: insufficient privilege to access object SYS.PLITBLM
242/6 PL/SQL: Statement ignored
242/22 PLS-00302: component 'EXISTS' must be declared
414/9 PL/SQL: Statement ignored
414/25 PLS-00302: component 'EXISTS' must be declared
600/6 PL/SQL: Statement ignored

LINE/COL ERROR
-------- -----------------------------------------------------------------
600/22 PLS-00302: component 'EXISTS' must be declared
756/7 PL/SQL: Statement ignored
756/23 PLS-00302: component 'EXISTS' must be declared
890/6 PL/SQL: Statement ignored
890/22 PLS-00302: component 'EXISTS' must be declared
966/2 PL/SQL: Statement ignored
966/18 PLS-00302: component 'FIRST' must be declared

Regards,
Sk
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 23 2005
Added on Nov 25 2005
12 comments
3,206 views