| Author |
Can not insert two long data into table with two varchar2 dataType column!
|
Jason Wu
Greenhorn
Joined: Sep 03, 2002
Posts: 13
|
|
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!
|
 |
jiang jiangwei
Greenhorn
Joined: Nov 12, 2002
Posts: 6
|
|
Now I will tell you the answer.
listen carefully!!
sorry! I don't know.Thanks
|
|
 |
|
|
subject: Can not insert two long data into table with two varchar2 dataType column!
|
|
|
0
