OraFAQ Forum: SQL & PL/SQL » ABOUT PROCEDURE

Home » SQL & PL/SQL » SQL & PL/SQL » ABOUT PROCEDURE

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

ABOUT PROCEDURE [message #1083]

Fri, 29 March 2002 06:44

AJITHKUMAR JANARDHANAN
Messages: 9
Registered: March 2002

Junior Member

HOW TO RETRIEVE THE BODY OF A PROCEDURE USING PL_SQL
I WAS USING ENTERPRISE MANAGER FOR SUCH THINGS..

IN WHICH TABLE U WUD FIND THE BODY OF A PROCEDURE

WILL IT BE IN A DATA DICTIONARY LIKE
DBA_OBJECTS OR DBA_TRIGGERS LIKE THAT

Report message to a moderator

Re: ABOUT PROCEDURE [message #1084 is a reply to message #1083]

Fri, 29 March 2002 07:35

Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

Look in dba_source.text

Report message to a moderator

Re: ABOUT PROCEDURE [message #1100 is a reply to message #1083]

Mon, 01 April 2002 08:02

AJITHKUMAR JANARDHANAN
Messages: 9
Registered: March 2002

Junior Member

thanks rajendran

i got that!!

Report message to a moderator

Previous Topic:	How can I see the SQL used to create a View?
Next Topic:	insert value into table is not working

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Apr 19 05:06:26 CDT 2024