Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Package Procedure Parameters

Re: Package Procedure Parameters

From: Jeremy <newspostings_at_hazelweb.co.uk>
Date: Thu, 8 Jul 2004 16:17:42 +0100
Message-ID: <MPG.1b5775f0baeed73989c8d@news.individual.net>


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

-- 

jeremy
Received on Thu Jul 08 2004 - 10:17:42 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US