Re: NEWBIE: how do I view a stored procedure from the command line?

From: Gennaro Napolitano <Gennaro.Napolitano_at_sbsitalia.it>
Date: Tue, 18 May 1999 14:50:54 +0200
Message-ID: <3741622D.2DE0C4D6@sbsitalia.it>

Anonymous wrote:

> Please help - I am having trouble with something simple... I've been using
> ORACLE for about a week now...
>
> <QUESTION>
>
> What is the syntax for viewing a stored procedure - from the command line
>
> </QUESTION>
>
> In other databases I can type "sp_helptext [procedure_name]" to view the
> source of the stored procedure on the command line.
>
> Thanks I really do appreciate any information on this

Try querying the system table 'USER_SOURCE'.

Ciao Gennaro Received on Tue May 18 1999 - 07:50:54 CDT