Dynamic SQL and Indicator Variables - Method 4

We have some code from Oracle 6 that does a dynamic SQL Query, using Method 4. Basically, the code receives a string:

SELECT TIMESTMP, ..... FROM TABLE WHERE A=2 AND ..... In Oracle 6, this worked absolutely great, but in Oracle 8.1.5.0.0, it core dumps at the FETCH. The only assistance that Oracle Support could be was "if you don't use indicator variables, unpredictable results, including Core Dumps will occur."

In looking through chapter 15 of the Pro*C manual, they go through their own demo. Never once through the demo do they mention ->X[], ->Y [] or ->Z[], the three items for indicator variables. (BTW, there is a bug in the manual, SQLNumberPrecV6() was previously known as sqlprc(), not sqlnul() as listed.)

I had to add the following include files:

EXEC SQL INCLUDE oraca;
EXEC SQL INCLUDE sqlcpr;

sqlcpr for the definition of the new calls, and oraca because sqlcpr required it. I also did a:

typedef void dvoid;

because I could not find a dvoid type in any include file, and sqlcpr's functions (that I need) required the type.

As you can tell, I did change my:

sqlald to SQLSQLDAAlloc
sqlnul to SQLColumnNullCheck
and
sqlprc to SQLNumberPrecV6

with no results.

Any help you can generate would be very appreciated.

Terry Steyaert
steyaert_at_my-deja.com

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Fri Feb 25 2000 - 06:39:53 CST