*
The moose likes JDBC and the fly likes can bind a LONG value only for insert into a LONG column Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Android Security Essentials Live Lessons this week in the Android forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "can bind a LONG value only for insert into a LONG column" Watch "can bind a LONG value only for insert into a LONG column" New topic
Author

can bind a LONG value only for insert into a LONG column

Henry Lowell
Ranch Hand

Joined: May 29, 2006
Posts: 63
We have a stored procedure in Oracle9i which handles both an INSERT and an UPDATE depending on whether or not the passed in GUID is null. The INSERT works just fine, but when doing the UPDATE we get the following error:


ORA-01461: can bind a LONG value only for insert into a LONG column
ORA-06512: at "PKG_USER_ACCT", line 164
ORA-06512: at line 1


There are no LONG column types in the table and I am not passing any LONG values (setLong). The only difference going into the procedure is the GUID being present or not which is of type CHAR(32). I've checked the length of the value going in and it is 32.

Does anyone know what might be causing this?


Hank
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: can bind a LONG value only for insert into a LONG column
 
Similar Threads
Oracle ORA-29902 Error!
ORA-01460: unimplemented or unreasonable conversion requested
Please help..triggers issue
SQL injection?
Error on trigger