From: vattekkat.babu@verizon.net   
      
   On Wed, 03 Sep 2003 01:49:03 -0700, Siva wrote:   
      
   > Hi,   
   >   
   > i would like to know the prcedure for viewing Stored Procedure   
   > Definition in SQL prompt. can anybody help me?   
   >   
   > thanxs & bye   
      
   SELECT   
       I.text   
   FROM   
       all_source I   
   WHERE I.type='PROCEDURE'   
     AND I.name='YOUR_PROCEDURE_NAME'   
     AND I.owner='SCHEMA_OWNER'   
   ORDER BY   
       I.line   
      
   You can get the source for FUNCTION, PACKAGE and PACKAGE BODY by changing   
   type = 'xx'   
      
   - Babu   
   http://vsbabu.org/   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)