| how to get LONG type data in Pro*C? [message #93473] |
Mon, 28 January 2002 18:42  |
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  |
Frank Naude
Messages: 4581
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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
