Re: HOWTO: Get the default value for an argument of Stored Function / Procedure using OCI

Interestingly enough the Dictionary view "ALL_ARGUMENTS" has a "DEFAULT_VALUE" column. However, this is always blank.

A bit of digging has resulted in finding out that this has been an Oracle bug since Oracle 7.

I'm using Oracle 9i (Release 1).

Still like to hear from anyone who has any thoughts on this.

Thanks

Adrian

"Adrian Capp" <adrian.capp_at_blueyonder.co.uk> wrote in message news:b19mbt$m68$1_at_sparta.btinternet.com...
> I'm using OCI to describe a Stored Procedure or Function to get the
> parameter list that it expects.
>
> All is well, except I want to access the parameters default value if one
has
> been specified.
>
> I'm using:
>
> OCIAttrGet(p_arg, OCI_DTYPE_PARAM, &ubHasDefault, 0,
> OCI_ATTR_HAS_DEFAULT, p_err)
>
> to determine if there is a default value and this works. However I do not
> know how to access the actual default value.
>
> Any help would be appreciated.
>
> Thanks
>
> Adrian Capp
> LBS Limted, UK
>
>
>
Received on Thu Jan 30 2003 - 00:02:06 CET