On 8i
SELECT PACKAGE_NAME,OBJECT_NAME,ARGUMENT_NAME,DATA_TYPE,IN_OUT,DEFAULT_VALUE
FROM USER_ARGUMENTS;
will give you what you want.
--
Niall Litchfield
Oracle DBA
Audit Commission UK
*****************************************
Please include version and platform
and SQL where applicable
It makes life easier and increases the
likelihood of a good answer
******************************************
"Morten" <usenet_at_kikobu.com> wrote in message
news:75db36f2.0211180639.2d807165_at_posting.google.com...
> Hello.
>
> SQL> desc ccs.bongbong
> PROCEDURE ccs.bongbong
> Argument Name Type In/Out Default?
> ------------------------------ ----------------------- ------ --------
> A VARCHAR2 IN DEFAULT
> B VARCHAR2 IN
>
> Can anyone explain to me what query 'desc' becomes? I wish to
> find out how it determines the default flag for the procedure
> arguments. This information is not in user_arguments.
>
> SQL> select argument_name, default_value from all_arguments
> 2 where object_name = 'BONGBONG';
>
> ARGUMENT_NAME DEFAULT_VALUE
> ------------------------------ --------------------
> A
> B
>
>
> Thanks,
>
> Morten
Received on Tue Nov 19 2002 - 03:44:19 CST
