Oracle-L: Re: list wrapped PL/SQL

From: <G.Plivna_at_itsystems.lv>
Date: Thu, 07 Mar 2002 04:43:21 -0800
Message-ID: <F001.00421BF6.20020307044321@fatcity.com>

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_at_sefas.        To:       Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>                    
                      co.uk>                   cc:                                                                                      
                      Sent by:                 Subject:  list wrapped PL/SQL                                                            
                      root_at_fatcity.com                                                                                                  
                                                                                                                                        
                                                                                                                                        
                      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: john.dunn_at_sefas.co.uk

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: ListGuru_at_fatcity.com (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: G.Plivna_at_itsystems.lv

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: ListGuru_at_fatcity.com (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).

Received on Thu Mar 07 2002 - 06:43:21 CST