Skip to Main Content
Forums

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!

ORA-06550 and PLS-00201 in PL/SQL Developer

Karan KukrejaFeb 4 2011 — edited Feb 7 2011
Hi all ,



I am facing the following error when i try to view the DDL of a table using pl/sql developer.

( right click on table and then DBMS_Metadata -> DDL)
ORA-06550: line 7, column 5:
PLS-00201: identifier 'SYS.DBMS_LOB' must be declared
ORA-06550: line 7, column 5:
PL/SQL: Statement ignored
ORA-06550: line 12, column 3:
PLS-00201: identifier 'SYS.DBMS_LOB' must be declared
ORA-06550: line 12, column 3:
PL/SQL: Statement ignored
ORA-06550: line 13, column 3:
PLS-00201: identifier 'SYS.DBMS_LOB' must be declared
ORA-06550: line 13, column 3:
PL/SQL: Statement ignored
Please suggest me what to do ?


regards
Kkukreja
This post has been answered by 789895 on Feb 4 2011
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 7 2011
Added on Feb 4 2011
7 comments
5,001 views