Oracle FAQ

Your Portal to the Oracle Knowledge Grid

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

Home -> Community -> Usenet -> c.d.o.misc -> Re: How do I see the source code of a stored procedure through Sql*plus ?

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

From: <tim.mcconechy_at_runtime.dk>
Date: Thu, 18 Mar 1999 11:53:45 GMT
Message-ID: <7cqpg7$dtd$1@nnrp1.dejanews.com>

Eller:

SET LONG 100000
select text from all_source where type='PROCEDURE' and NAME='YOUR_NAME'

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Thu Mar 18 1999 - 05:53:45 CST

This message: [ Message body ]
Next message: Mike Burden: "Re: Why use LONG?"
Previous message: Niall Litchfield: "Re: Ora 7.1 on Win95 Stack Overflow on ODBC Application But NT OK?"
In reply to: XU: "Re: How do I see the source code of a stored procedure through Sql*plus ?"
Next in thread: Steven Franklin: "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