Re: How do I see the source code of a stored procedure through Sql*plus ?

From: Ajay Arora <aarora_at_flash.net>
Date: Tue, 16 Mar 1999 21:10:26 GMT
Message-ID: <01be6ff1$39cb9f80$f406050a@arora00.polk.com>

if you are the owner of the procedure, and the procedure is not wrapped, you can do the following query

SELECT TEXT FROM USER_SOURCE
where name = 'PROCEDURE_name'

Regards,
Ajay Arora

sreeramav_at_my-dejanews.com wrote in article <7cmf3u$qdv$1_at_nnrp1.dejanews.com>...
> How do I see the source code of a stored procedure through Sql*plus ?
>
> -----------== Posted via Deja News, The Discussion Network ==----------
> http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own

>
Received on Tue Mar 16 1999 - 15:10:26 CST

This message: [ Message body ]
Next message: devinder: "Memory needed by Multi Thraded Server and Despatcher Process"
Previous message: Ajay Arora: "listener not starting up...."
In reply to: sreeramav_at_my-dejanews.com: "How do I see the source code of a stored procedure through Sql*plus ?"
Next in thread: Emmanuel Bontemps: "Re: How do I see the source code of a stored procedure through Sql*plus ?"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US