Home » RDBMS Server » Server Administration » View all procedures
View all procedures [message #132716] Mon, 15 August 2005 19:25 Go to next message
PompeytilIDie
Messages: 9
Registered: March 2005
Location: Western Australia
Junior Member
Would anyone out there know of a way of allowing a user (a maverick developer!) to view all the procedures in a given schema?

I've looked into the DBMS_DESCRIBE but the pl/sql wrappers preclude using it, plus it needs heaps of parameters passed to it and requires the user to know what the procedure is called in the first place.

Of course my answer to said cowboy is to put all code in a software safe and make it liable to the same change control policies as everything else we do Smile

Report message to a moderator

Re: View all procedures [message #132794 is a reply to message #132716] Tue, 16 August 2005 04:44 Go to previous messageGo to next message
girish.rohini
Messages: 744
Registered: April 2005
Location: Delhi (India)
Senior Member
query all_procedures (for all accessible procedures for a user) & all_source (for definition text of procedure)

Report message to a moderator

Re: View all procedures [message #132811 is a reply to message #132794] Tue, 16 August 2005 05:43 Go to previous message
Maaher
Messages: 7065
Registered: December 2001
Senior Member
And in USER_ARGUMENTS you can find the parameters...

MHE

Report message to a moderator

Previous Topic: knowing password - possible??
Next Topic: Problem Re-Starting the database instance
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sun Jan 26 10:23:56 CST 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.