Re: How I know in the dictionary a procedure is wrapped

On 07/27/2004 01:13:11 PM, Tanel P?der wrote:

> I don't know of any DD columns which explicitly state whether a PL/SQL
> object is wrapped or not, you just have to check into the source, where you
> have a "wrapped" keyword after object type and object name.

Tanel, let me try and help out here:

select distinct name,owner,type from dba_source where lower(text) like '% wrapped%'
/

If you check all the entries, you'll see that each and every one of them is wraped.

~

-- 
Mladen Gogala
Oracle DBA
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to:  oracle-l-request_at_freelists.org
put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------