Oracle 7.3.4

I am working on an ESQL based ANSI C tool for processing dynamic queries against Oracle. The developer who wrote the code got huge performance increase when the saved off the sqlctx value and restored it to enable them to "reuse bind information" in Oracle 7.3.2 this works fine but in Oracle 7.3.4 sqlctx is still set to 0 after the call to EXEC SQL PREPARE... and while everything binds and runs the first time the query is executed subsequent executions of the same query now fail with an ORA-1007 "Variable not in select list"

I am not really familiar with the SQLCA and SQLDA internal variables and cannot tell if perhaps sqlctx is in fact the problem...I only noticed that under 7.3.2 this field contained what appears to be an address after the call to EXEC SQL PREPARE and under 7.3.4 it is still 0.

If anyone could provide some clues I would be very grateful

 Thanks,
   Chuck

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Thu Jul 22 1999 - 10:36:01 CDT