| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re: list procedure code
John,
There are a few preliminary setps to follow before you get the source code =
for a procedure.
a. desc dba_source the get the table description that holds the code. b. select distinct(name) from dba_source to get all the named = procedures in your schema. c. set text long to allow for the text to be displayed on your screen.d. select text from dba_source where name=3D'the name of the procedure' spool the output if a hard copy is needed. Do NOT use windows editor = because it can leave unseen characters in the text for and compile will = fail.
Hope this is sufficient.
Ron=20
DBA
Atl,GA
>>> john.dunn_at_sefas.co.uk 07/17/00 11:59AM >>>
How can I list the source code of a procedure from sqlplus?
John
--=20
Author: John Dunn
INET: john.dunn_at_sefas.co.uk=20
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists --------------------------------------------------------------------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 Mon Jul 17 2000 - 12:50:06 CDT
 |
 |