Re: Package Procedure Parameters

From: Quantarc <info_at_quantarc.co.uk>
Date: Fri, 09 Jul 2004 09:02:37 +0100
Message-ID: <40ee5113$0$552$ed2619ec@ptn-nntp-reader01.plus.net>

Anurag Varma wrote:
> "Quantarc" <info_at_quantarc.co.uk> wrote in message news:GQcHc.4378$Fc7.803601_at_stones.force9.net...
>

>>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.
>>
>>thanx.
>>rod.

>
>
> Is this what you are looking for:
>
> desc <packagename>
>
> or
>
> look into user_arguments, all_arguments ....
>
> Anurag
>
>

thank you both, i'll take alook into them. aslong as someone tells me it is possible then i can go on looking.

cheers!

rod. Received on Fri Jul 09 2004 - 03:02:37 CDT