Home » Developer & Programmer » Precompilers, OCI & OCCI » how to get LONG type data in Pro*C?
how to get LONG type data in Pro*C? [message #93473] Mon, 28 January 2002 18:42 Go to next message
icewolf li
Messages: 1
Registered: January 2002
Junior Member
following code results oracle error:
ORA-00932: inconsistent datatypes

EXEC SQL BEGIN DECLARE SECTION;
char testWords[[4000]];
EXEC SQL END DECLARE SECTION;
EXEC SQL WHENEVER SQLERROR goto sqlerror;
EXEC SQL select words into :testWords from data_words where rownum=1;

How to get LONG data from database then?
Re: how to get LONG type data in Pro*C? [message #93479 is a reply to message #93473] Fri, 01 February 2002 03:56 Go to previous message
Frank Naude
Messages: 4579
Registered: April 1998
Senior Member
Hi,

You should consider migrating your LONG columns to LOBs. Oracle plans to end support of LONG and LONG RAW columns in future releases. These columns are supported for backward compatibility only.

If you cannot convert to LOBs, consider using low-level OCL calls to fetch data piece-wise from the LONG. There is also a great example of how to fetch long column values piece-wise from PL/SQL on this FAQ. See http://www.orafaq.net/scripts/plsql/readlong.txt.

Best regards.

Frank Naude
Previous Topic: incorrect file suffix error in Pro*c
Next Topic: proc does not terminate
Goto Forum:
  


Current Time: Thu Mar 28 14:26:33 CDT 2024