Re: How to get the code of the stored procedure/package?

>> Grace Tsai wrote:

 Does anybody know how to get the code of the stored procedure/package?
>>
 

>>Hakan Eren replied

 SELECT text FROM user_source
   WHERE name like 'YourProcFuncOrPAckageNAme' (o==> name = '....')    ORDER BY line;
>>

Well, that will almost do it, but if you've got similarly named objects that LIKE is going to give you problems and if you are selecting package text you'll have your spec and body all mixed up.

Try
 SELECT text FROM user_source
   WHERE name = 'YourProcFuncOrPAckageNAme'    ORDER BY type,line ASC

John Received on Tue Dec 23 1997 - 00:00:00 CST