Can not insert two long data into table with two varchar2 dataType column!

[Jason Wu]

Table Test(
text1 varchar2(4000),
text2 varchar2(4000)
);
Two test case using Pro*c for 8i, Databse code is JA16EUC:
Case1: (EXEC SQL　DECLARE)
char text1[2000];
char text2[2000];
Running under Windows is ok,
but under Solaris, error code: ORA-01461 can bind a LONG value only for insert into a LONG column
Case2: (EXEC SQL　DECLARE)
char text1[1333];
char text2[1333];
Test result is ok.

Case3: (EXEC SQL　DECLARE)
char text1[4000];
char text1[1000];
Test result is ok.
Thanks for your help!

[Mark Spritzler]

I know one thing you cannot have more than one long field in a table in Oracle.
OK I see you question wasn't along those lines.
Can you do a Substr on the long field to make it the size of the varchar2, or one less char, that might make it allow the entry.

Mark
[ November 13, 2002: Message edited by: Mark Spritzler ]