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

From: Tanel Põder <tanel.poder.003_at_mail.ee>
Date: Tue, 27 Jul 2004 20:26:43 +0300
Message-ID: <3e6a01c473fe$e335fc70$0a879fd9@porgand>

> Thanks TAnel, this is the best I got meanwhile
> select * from dba_source where text like '% wrapped%' and line =1

Just in case use lower(text) like '% wrapped%' (and I'm not entirely sure whether the wrapped keyword cant be at 2nd or 3rd or on any greater line.., but at least in my test databases all the really wrapped packages have the keyword on the first line source line).

Tanel.

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:23:26 CDT