Re: OCI describe parameters
From: Paul Dembry <pade_at_trifox.com>
Date: 17 Dec 2002 10:53:12 -0800
Message-ID: <7d6c6aa5.0212171053.2d2e7278_at_posting.google.com>
> > each parameter before using OCIAttrGet() on the parameter handle to
> retrieve
> > the OCI_ATTR_DATA_TYPE and OCI_ATTR_DATA_SIZE attributes for each.
This does not work for insert/update statements because OCIStmtExecute wants the bound parameters even with OCI_DESCRIBE_ONLY. Otherwise I keep getting 24333: zero iteration count. Paul Received on Tue Dec 17 2002 - 19:53:12 CET
Date: 17 Dec 2002 10:53:12 -0800
Message-ID: <7d6c6aa5.0212171053.2d2e7278_at_posting.google.com>
"Paul Dembry" <pade_at_nospam.trifox.com> wrote in message news:<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.
This does not work for insert/update statements because OCIStmtExecute wants the bound parameters even with OCI_DESCRIBE_ONLY. Otherwise I keep getting 24333: zero iteration count. Paul Received on Tue Dec 17 2002 - 19:53:12 CET