Re: Text of a stored procedure

From: skv <skv_at_kpbank.ru>
Date: Thu, 23 Apr 1998 08:44:17 +0800
Message-ID: <6hm2li$rnu$1@home.kpbank.ru>

Scott Patterson пишет в сообщении <353e602b.0_at_feed1.realtime.net> ...
>I need to extract the text of a stored procedure. Is there an Oracle
>procedure similar to the SQLServer sp_helptext? Or some other means of
>extracting the text?
>

    SELECT text

       FROM ALL_SOURCE
    WHERE owner = your_owner

         AND   name = your_name
         AND   type = your_proc_type

   ORDER BY line;
>Scott Patterson
>
>
>
>

Regards

---

         Konstantin V. Sartakov
                Kuzbassprombank
                       Kemerovo
                         Russia
           mailto:skv_at_kpbank.ru

Received on Wed Apr 22 1998 - 19:44:17 CDT