OraFAQ Forum: Server Administration » sored procerdure and function

Home » RDBMS Server » Server Administration » sored procerdure and function

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

sored procerdure and function [message #59872]

Tue, 30 December 2003 19:11

M. Khaled
Messages: 67
Registered: April 2002

Member

please help me to see stored procedure and function.show me a query for this

thanks

Report message to a moderator

Re: stored procerdure and function [message #59875 is a reply to message #59872]

Tue, 30 December 2003 21:28

Frank Naude
Messages: 4580
Registered: April 1998

Senior Member

Hi,

You can see the stored procedures and functions defined for your schema by querying the USER_SOURCE view.

Look at this example:

-- List all Procedures and Functions in my schema...
SELECT DISTINCT type, name
FROM   user_source 
WHERE  type = 'PROCEDURE' or  type = 'FUNCTION';

-- Look at the code for one of the above...
SELECT text 
FROM   user_source
WHERE  name = '&name'
ORDER  BY line;

Best regards.

Frank

Report message to a moderator

Previous Topic:	What does an UNKNOWN state mean
Next Topic:	Temporary TBS : Connection Pooling Clarification

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 10:31:09 CDT 2024