Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: "NOT NULL value" for procedure arguments using user_arguments
usenet_at_kikobu.com (Morten) 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
It appears that one needs to use sys.argument$ That table (view?) has a bit that shows if an argument has a default value or not.
Morten Received on Tue Nov 19 2002 - 05:01:04 CST