• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Tim Cooke
  • paul wheaton
  • Paul Clapham
  • Ron McLeod
Sheriffs:
  • Jeanne Boyarsky
  • Liutauras Vilda
Saloon Keepers:
  • Tim Holloway
  • Carey Brown
  • Roland Mueller
  • Piet Souris
Bartenders:

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

 
Ranch Hand
Posts: 63
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
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?
 
reply
    Bookmark Topic Watch Topic
  • New Topic