>Hi Mike,
>This depends on your Oracle database version as well as the way you connect.
>Might be easier if you provide: Oracle DB version and ODBC driver and if you are using SQL passthrough or what?
Tim,
Sorry for not giving the extra info. I'm using Oracle 8i. And the query is done by SPT using the 'Oracle ODBC Driver' Version: 8.01.07.00
I tried:
lcSqlStatement = "SELECT addr_no, cust_no, " +;
"DBMS_LOB.SUBSTR(addr_line,1,255) AS addr_line, " +;
"city, state_cd, cntry_cd, zip_cd " +;
"FROM addr_dtl " +;
"WHERE addr_dtl.addr_no = " + TRANS(lnCustAddrNo)
But the value in the returned cursors' field was .NULL. I checked the table and there is a value in the field
Am I still missing something?
Mike