Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Package Procedure Parameters
In article <GQcHc.4378$Fc7.803601_at_stones.force9.net>, Quantarc says...
> hi, i have searched around on the web and through the oracle
> documentation i have, and not been able to find any information about my
> problem, so i was hoping someone here may be able to point me in the
> right direction.
>
> is there any way to discover a package procedures parameters from
> oracle, names and the order they are in? (oracle 9.2)
>
> i don't know if ths is even possible so a yes or no would be great if
> anyone knows, just so i know i'm not wasting my time trying to find out.
>
Within SQL Plus
SQL> desc <package_name>
will give you (what I think) you are asking for
-- jeremyReceived on Thu Jul 08 2004 - 10:17:42 CDT