| How to get Package.Procedure's Parameter information? [message #272568] |
Fri, 05 October 2007 10:03  |
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.
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
