Hi ,
I am on oracle 11.10.7.0.
I have oracle client and PL/SQL installed on my windows XP machine and
today while i was checking some table in PL/SQL.. i got the following error when i tried to view the DML for that table.( right click on table name -> 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
Its not coming for one table but for all the tables.. Any help would be appreciated.
Regards
Kkukreja