Re: OCI describe parameters
From: Paul Dembry <pade_at_nospam.trifox.com>
Date: 05 Dec 2002 21:49:08 GMT
Message-ID: <asohkk$c5r_at_dispatch.concentric.net>
Date: 05 Dec 2002 21:49:08 GMT
Message-ID: <asohkk$c5r_at_dispatch.concentric.net>
> Prepare the statement with OCIPrepare(), then use OCIStmtExecute() in
> OCI_DESCRIBE_ONLY mode, then you can use OCIAttrGet() to get the
> OCI_ATTR_PARAM_COUNT attribute of the statement handle, then loop through,
> doing an OCIParamGet() on the statement handle to get an OCIParam handle
for
> each parameter before using OCIAttrGet() on the parameter handle to
retrieve
> the OCI_ATTR_DATA_TYPE and OCI_ATTR_DATA_SIZE attributes for each.
Thanks Ken, I'll give it a try. I misinterpreted the OCI_ATTR_PARAM_COUNT
description in the manual to mean that it only worked for a select list.
Paul
Received on Thu Dec 05 2002 - 22:49:08 CET