Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Oracle 7.3.4

Oracle 7.3.4

From: <crharvey_at_my-deja.com>
Date: Thu, 22 Jul 1999 15:36:01 GMT
Message-ID: <7n7dp0$ubv$1@nnrp1.deja.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US