开发者

Is it possible to retrieve a raw query from Oracle OCI library?

开发者 https://www.devze.com 2023-01-05 02:13 出处:网络
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

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;
0

精彩评论

暂无评论...
验证码 换一张
取 消