Win a copy of Functional Reactive Programming this week in the Other Languages forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

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

 
Jason Wu
Greenhorn
Posts: 13
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 6
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Now I will tell you the answer.
listen carefully!!
sorry! I don't know.Thanks
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic