HOWTO: Get the default value for an argument of Stored Function / Procedure using OCI
From: Adrian Capp <adrian.capp_at_blueyonder.co.uk>
Date: Wed, 29 Jan 2003 22:59:10 +0000 (UTC)
Message-ID: <b19mbt$m68$1_at_sparta.btinternet.com>
[Quoted] I'm using OCI to describe a Stored Procedure or Function to get the parameter list that it expects.
Date: Wed, 29 Jan 2003 22:59:10 +0000 (UTC)
Message-ID: <b19mbt$m68$1_at_sparta.btinternet.com>
[Quoted] 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 [Quoted] 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 Wed Jan 29 2003 - 23:59:10 CET