This week's book giveaway is in the OO, Patterns, UML and Refactoring forum. We're giving away four copies of Refactoring for Software Design Smells: Managing Technical Debt and have Girish Suryanarayana, Ganesh Samarthyam & Tushar Sharma on-line! See this thread for details.
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?
I’ve looked at a lot of different solutions, and in my humble opinion Aspose is the way to go. Here’s the link: http://aspose.com
subject: can bind a LONG value only for insert into a LONG column