LONG DATA TYPE PROBLEM
From: Bruce Arbuckle <brucea_at_atlas.com>
Date: Sat, 3 Dec 1994 00:02:06 GMT
Message-ID: <1994Dec3.000206.23037_at_atlas.com>
Date: Sat, 3 Dec 1994 00:02:06 GMT
Message-ID: <1994Dec3.000206.23037_at_atlas.com>
I seem to be doing someting wrong and I hope someone can set me straight. Oracle 6.
I do the following
sqlplus usr/pswd
set long 2000
create table long_test (lt_num number, lt_long long);
insert into long_test values (1,
'<220 characters of data>'||
'<100 characters of data>');
1 row inserted
column lt_long format A500;
select lt_long from long_test;
gives me 500 -- in header and 255 characters.
in pro*c program
EXEC SQL BEGIN DECLARE ..
varchar ORA_LONG[2000];
EXEC SQL END....
EXEC SQL SELECT LT_LONG INTO :ORA_LONG FROM LONG_TEST
WHERE LT_NUM = 1;
using unix debugger, I get no error on the select.
ORA_LONG = 255.
print of ORA_LONG.arr shows only 255!
What am I doing wrong?
Sequent PTX system
--
Bruce Arbuckle EMAIL: brucea_at_adcmail.atlas.com
Received on Sat Dec 03 1994 - 01:02:06 CET