Re: How to get SQL from OCIStmt

From: Cliff Dabrowski <_NOSPAM_cliffd.ng_at_bigfoot.com>
Date: Fri, 10 Jan 2003 13:14:37 -0500
Message-ID: <3e1f0d88$1@172.22.1.229>

Igor,

The statement handle definition is opaque and the structure is undefined. There is no defined way to retrieve the SQL text associated with a statement handle. However, Please explain more about what you are trying to achieve and I may be of further assistance.

"Igor Sidorin" <i_sidorin_at_hotmail.com> wrote in message news:1b3cae17.0301090813.15d7db48_at_posting.google.com...
> Hi,
>
> Does anyone know if there is a way in OCI to obtain the SQL statement
> string from an OCIStmt? For example, if I call OCIPrepareStmt(), and
> then bind the data, can I obtain the final SQL statement string from
> OCIStmt just before I call OCIStmtExecute()? What about the original
> string that was passed to OCIPrepareStmt() (before any bindings)? In
> other words, does anyone know what the structure of OCIStmt is?
>
> Thanks!
>
> Igor
Received on Fri Jan 10 2003 - 12:14:37 CST