Thanks TAnel, this is the best I got meanwhile select * from dba_source where text like '% wrapped%' and line =1 Juan Carlos Reyes Pacheco OCP -------Original Message------- From: oracle-l@xxxxxxxxxxxxx Date: 07/27/04 11:39:16 To: oracle-l@xxxxxxxxxxxxx Subject: Re: How I know in the dictionary a procedure is wrapped There should be a 'package body <name> wrapped' string in first line of each wrapped package body. Tanel. ----- Original Message ----- From: "Stephane Faroult" <sfaroult@xxxxxxxxxxxx> To: <oracle-l@xxxxxxxxxxxxx> Sent: Tuesday, July 27, 2004 6:27 PM Subject: Re: How I know in the dictionary a procedure is wrapped > STFV DBA_SOURCE ... > Regards, ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //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@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------