Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Re:PLSQL stored procedure
Adrian,
Look in USER_SOURCE. The TEXT field will have the source code.
Dick Goulet
____________________Reply Separator____________________ Author: Adrian Ciocildau <adri_l_at_gmx.net> Date: 3/5/2003 5:34 AM
Hi.
i need some help. i'm trying to get a stored procedure source code from the database.
After a lot of reding i found :
select * from user_objects where object_type='PROCEDURE';
and i've got the name and Object_id of that prodedure but i have no ideea how to get the rest :(
please help,
adrian
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Adrian Ciocildau
INET: adri_l_at_gmx.net
Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services ---------------------------------------------------------------------To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author:
INET: dgoulet_at_vicr.com
Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services ---------------------------------------------------------------------To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Wed Mar 05 2003 - 08:19:19 CST
![]() |
![]() |