Home » SQL & PL/SQL » SQL & PL/SQL » How to get Package.Procedure's Parameter information?
How to get Package.Procedure's Parameter information? [message #272568] Fri, 05 October 2007 10:03 Go to next message
rasa
Messages: 45
Registered: February 2006
Member
I have the following requirement.

Say, I have a Procedure within a Package like this:
CREATE OR REPLACE PACKAGE MYPACKAGE

PROCEDURE MYPROC
(
   p_PARAM1 IN DATE,
   p_PARAM2 IN VARCHAR2
);

END MYPACKAGE;


Which View/Table should I query to determine what parameters are applicable for MYPACKAGE.MYPROC?

If I specify "MYPACKAGE.MYPROC" I need to know that there are 2 parameters, the first of which is p_PARAM1 and that it is of DATE datatype and that p_PARAM2 is the second and it is of type VARCHAR2?

Please help.
Re: How to get Package.Procedure's Parameter information? [message #272574 is a reply to message #272568] Fri, 05 October 2007 10:14 Go to previous messageGo to next message
BlackSwan
Messages: 25050
Registered: January 2009
Location: SoCal
Senior Member
SQL> DESC DBA_SOURCE
SQL> DESC MYPACKAGE.MYPROC

[Updated on: Fri, 05 October 2007 10:14] by Moderator

Report message to a moderator

Re: How to get Package.Procedure's Parameter information? [message #272576 is a reply to message #272568] Fri, 05 October 2007 10:22 Go to previous message
Michel Cadot
Messages: 64151
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
ALL_ARGUMENTS
DBA_ARGUMENTS
USER_ARGUMENTS

Regards
Michel
Previous Topic: Random value
Next Topic: XML EXtract problem (NOT urgent. never was never will be)
Goto Forum:
  


Current Time: Fri Dec 09 15:32:22 CST 2016

Total time taken to generate the page: 0.13709 seconds