Home » SQL & PL/SQL » SQL & PL/SQL » Stored Procedure status- Oracle
Stored Procedure status- Oracle [message #188536] Sat, 19 August 2006 03:07 Go to next message
mymot
Messages: 225
Registered: July 2005
Senior Member
Hi,

Wondering which table in oracle db give us detail about store procedures status (valid,invalid etc)

dba_procedures
user_procedures



Thanks
Re: Stored Procedure status- Oracle [message #188538 is a reply to message #188536] Sat, 19 August 2006 03:23 Go to previous message
dhananjay
Messages: 635
Registered: March 2002
Location: Mumbai
Senior Member
hi,


select status from user_objects or all_objects
where =your_proc_name



regards,
Previous Topic: Out Parameter
Next Topic: Data migration from XML source to Oracle
Goto Forum:
  


Current Time: Thu Dec 08 00:19:51 CST 2016

Total time taken to generate the page: 0.08513 seconds