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

Hi Mladen how are you?
I thought you was going to block my threats, So this means we are in peace again :)  

Juan Carlos Reyes Pacheco
OCP
-------Original Message-------  

From: oracle-l_at_freelists.org
Date: 07/27/04 13:28:59
To: oracle-l_at_freelists.org
Subject: 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
-----------------------------------------------------------------
----------------------------------------------------------------
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
-----------------------------------------------------------------