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!

synonym of Stored procedure in invalid status

630047Jul 30 2009 — edited Jul 30 2009

Hi experts,

Am using synonym for one stored procedure created by Admin user it was run fine till last week as scheduled
This stored procedure created with DDL statement ( execute immediate) so it recompile every time of execution.
This time error with ORA-06575 ,when I was checking in ALL_OBJECTS my stored procedure & Synonym showing me as “invalid” status.

If I want to raise a request to DBA is it enough to recreate Stored procedure alone or Synonym ?

Lots of Thanks in advance
Kalinga

Locked Post

New comments cannot be posted to this locked post.

Locked on Aug 27 2009

Added on Jul 30 2009

4 comments

1,709 views