Home » Developer & Programmer » JDeveloper, Java & XML » java.sql.SQLException: ORA-01461: can bind a LONG value only for insert into a LONG column
java.sql.SQLException: ORA-01461: can bind a LONG value only for insert into a LONG column [message #272047] Wed, 03 October 2007 14:51 Go to next message
caprikar
Messages: 226
Registered: March 2007
Senior Member
Hi,
I have a tables with one of the columns as CLOB datatype. When I try to update the table some time i get the following error:

java.sql.SQLException: ORA-01461: can bind a LONG value only for insert into a LONG column
It goes away if i try to update the same values after sometime.

Any idea why I'm getting this error?
Thanks,
GK
Re: java.sql.SQLException: ORA-01461: can bind a LONG value only for insert into a LONG column [message #272159 is a reply to message #272047] Thu, 04 October 2007 02:34 Go to previous message
dimis283
Messages: 38
Registered: July 2007
Location: greece
Member
Maybe if you update clob field you have to change the type of that java element at "Clob type" .
Java link.
I find this and this.
Dimis

[Updated on: Thu, 04 October 2007 02:56]

Report message to a moderator

Previous Topic: How to get the functionality of Active X in Oracle 10g
Next Topic: Parsing XML in Oracle 9i
Goto Forum:
  


Current Time: Fri Mar 29 06:21:38 CDT 2024