It isn't an elegant solution but You can just look into source
Something like
SELECT
owner
,type
,name
FROM all_source
WHERE line = 1
AND upper(text) like '%WRAPPED%'
ORDER BY
owner
,type
,name;
Gints Plivna
IT Sist�mas, Mer�e�a 13, LV1050 R�ga
http://www.itsystems.lv/gints/
John Dunn
<john.dunn@sefas. To: Multiple recipients of list
ORACLE-L <[EMAIL PROTECTED]>
co.uk> cc:
Sent by: Subject: list wrapped PL/SQL
[EMAIL PROTECTED]
2002.03.07 13:53
Please respond to
ORACLE-L
Is there a query I can run to find out which PL/SQL packages are wrapped
and
which are not?
Oracle 8.1.7
John
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: John Dunn
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
