Is it possible to retrieve a raw query from Oracle OCI library?
I am looking to retrieve the raw query bytes from an Oracle statement and copy them directly into a POD C structure. The reason for this is due to legacy code that must be ported to using Oracle from Informix. I'll illustrate what I basically need below. I have been looking into using the Oracle Template Library (OTL) but I have been unable to thus far find a way to retrieve the underlying byte data directly from the stream.
The problem is that I want to issue several SELECT queries, with varying column outputs, from the same function call (this is the current mode of operation for Informix).
int 开发者_C百科query( char* inputQueryBuf, char* outputQueryBuf);
Sorry to unburry this old thread, but why can use the oracle v$sql
to retrieve recently running queries?
SELECT *
FROM gv$sql;
精彩评论