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

From: phil chang <pxchang0_at_sunspot.wcc.com>
Date: 1997/12/15
Message-ID: <6742ud$8gd$1@news-2.csn.net>#1/1

select	text
from	user_source
where	name = upper('&proc_name')
and	type = upper('&type')

order by line;

&type = procedure or package, depending on which you want

In article <34957803.446B_at_ribm00.rhic.bnl.gov>, Grace Tsai <gtsai_at_ribm00.rhic.bnl.gov> says:
>
>Does anybody know how to get the code of the stored procedure/package?
>I lost some of the files of procedures and packages, but I installed
>them in sqlplus before I lost them. How to get the codes? Any help would
>be greatly appreciated. Thanks in advance.
>
>Grace Tsai
>Brookhaven National Lab
  Received on Mon Dec 15 1997 - 00:00:00 CST