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!

How to recompile a procedure by SqlPlus

Mark1970Feb 8 2010 — edited Feb 8 2010

If I don't want to use a tool (Sql developer, Toad, ...) for compiling a stored procedure, can anyone tell me how I can do it directly by SqlPlus? I mean which are the Oracle tables where I suppose there's a flag telling me if a procedure results uncompiled and how can I automatically write a little batch in SQL for recompiling all what is uncompiled at a certain moment?
Thanks!

Edited by: Mark1970 on 8-feb-2010 0.52

This post has been answered by 730428 on Feb 8 2010

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Mar 8 2010

Added on Feb 8 2010

3 comments

62,377 views