Re: How to get the parameter list of an Oracle SP at run-time
- From: "Michael Jacobs" <iq193@xxxxxxxxxxxxx>
- Date: Fri, 3 Jun 2005 12:02:17 -0400
Bill,
you can do a 'describe' on the package or procedure and Oracle wll return
the list of parameters and their attributes, one per line.. Here are a
couiple of examples:
desc sys.close
PROCEDURE CLOSE
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
OBJECTID NUMBER IN
EXCEPT SQLOLAPIEXCEPTION OUT
desc sys.evaluatebooleanexpression
PROCEDURE EVALUATEBOOLEANEXPRESSION
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
OBJECTID NUMBER IN
EXPRESSION NVARCHAR2 IN
NAOUT NUMBER(38) OUT
ID NUMBER(38) IN
RET NUMBER(38) OUT
EXCEPT SQLOLAPIEXCEPTION OUT
HTH,
Michael
"Bill N" <billnielsen@xxxxxxxxxxx> wrote in message
news:42a034b4@xxxxxxxxxxxxxxxxxxxxxxxxx
> I'm using Delphi 6, ADO 2.7 and Oracle 9i. I would like to create a
> procedure where I pass a valid stored procedure name and it returns the
> parameters (parameter name, data type, precision (when required)).
>
> Anyone know how I can do this?
>
> Thanks,
> Bill N
>
>
.
- References:
- Prev by Date: How to convert query's result to physical Table?
- Next by Date: Re: How to convert query's result to physical Table?
- Previous by thread: How to get the parameter list of an Oracle SP at run-time
- Next by thread: How to convert query's result to physical Table?
- Index(es):
Relevant Pages
|
