wood burning stoves 2.0*
The moose likes JDBC and the fly likes Can not insert two long data into table with two varchar2 dataType column! Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Can not insert two long data into table with two varchar2 dataType column!" Watch "Can not insert two long data into table with two varchar2 dataType column!" New topic
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!
 
Similar Threads
Problem of using setCharacterStream method to insert varchar2 data in ORACLE816
Can not insert two long data into table with two varchar2 dataType column!
Concatination 3 columns of VARCHAR2(4000) to return a ResultSet with one column
Problem of using setCharacterStream method to insert varchar2 data in oracle816
Problem of using setCharacterStream method to insert varchar2 data in ORACLE816