Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> 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 -----------------------------------------------------------------Received on Tue Jul 27 2004 - 12:42:33 CDT
![]() |
![]() |