OraFAQ Forum: SQL & PL/SQL » Database procedure

Home » SQL & PL/SQL » SQL & PL/SQL » Database procedure

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

Database procedure [message #19810]

Wed, 10 April 2002 21:23

Gopal Raw
Messages: 19
Registered: January 2002

Junior Member

How can i get the script of a stored procedure from
the database if the sql source is not present.

Report message to a moderator

Re: Database procedure [message #19814 is a reply to message #19810]

Wed, 10 April 2002 21:40

Todd Barry
Messages: 4819
Registered: August 2001

Senior Member

http://asktom.oracle.com/pls/ask/f?p=4950:8:680839::NO::F4950_P8_DISPLAYID,F4950_P8_CRITERIA:2082363896922

Report message to a moderator

Re: use user_source to generate the script [message #19818 is a reply to message #19810]

Thu, 11 April 2002 02:30

P.Deshmukh
Messages: 17
Registered: March 2002

Junior Member

Hi,
You can get from the data dictionary ,user_source.

select text from user_source where name=upper('proc_name) order by line;

I hope this will do.
-Bye

Report message to a moderator

Previous Topic:	Explain The Query
Next Topic:	VERY URGENT: HOW CAN I ROUND A NUMERIC VALUE UP TO THE HUNDREDS.

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Apr 26 09:07:34 CDT 2024