Re: ORA 06508 on DBMS_SQL.PARSE

Andrea wrote:
>
> Hi amd sorry for my english,
>
> I have a problem; after a shutdown of my oracle instance (Oracle 7.2
> running over Netware) I'm was testing a function wich call the pakage
> DBMS_SQL.
>
> When my function use then DBMS_SQL.PARSE function Oracle return the error
> in subject. I don't know why because before shutdown all was right.

  What kind of mode do you use in shutdown ? You can try to recompile the procedure or rebuild the DBMS_SQL again.

---
Name   : Lun Wing San (Certified Oracle Database Administrator)

Title  : Oracle Application Developer of Hong Kong Productivity Council
         Oracle Database Administrator and System Administrator of QRC
Phone  : (852)27885841

This posting represents the personal opinions of the author. It is not the
official opinion or policy of the author's employer. Warranty expired when you
opened this article and I will not be responsible for its contents or use.