Re: How to get stored procedure definition?

[Frank Swarbrick]

You should be able to use Control Center. Find the folder Stored Procedures
in the Application Objects folder. Each procedure will be listed, and there
is a column called Input Parameters that should help. Also you can click on
the one you want and it will show Parameter Details with the Name, Data type
and Mode (IN, OUT, INOUT).

n 6/5/2008 at 8:15 AM, in message
<8d**********************************@a1g2000hsb.g ooglegroups.com>,
Jagger<Pa*********@gmail.comwrote:

On a remote system I got a stored procedure named MY_STORED_PROCEDURE.
However there is a problem because I am not sure of the interface of
it (number of
parameters and types of them). I have googled, read documentation but
I haven't
found an appropriate syntax for quering database for description of
already created
stored procedure.

Does such statement exist? If it exists does someone know how it
should look
like?

--
Best regards
Jagger