Win a copy of Mesos in Action this week in the Cloud/Virtualizaton forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

ORA-01460: unimplemented or unreasonable conversion requested

 
nikil shar
Ranch Hand
Posts: 116
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
no doubt this has something to do with BLOB type.

anyway am getting this error when trying to insert a pdf document as a BLOB into an oracle db.



have verified that the sql works without the BLOB type.

any ideas what could be wrong ??



ta.
 
Jeanne Boyarsky
author & internet detective
Marshal
Posts: 34410
346
Eclipse IDE Java VI Editor
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I think the first thing is to rule out the pdf file itself. (Maybe it is too large or has some odd character in it.) Can you create an image or word file and try inserting that?
 
nikil shar
Ranch Hand
Posts: 116
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
i found that if i insert a row without the BLOB and then update it with the BLOB it works fine !!! how strange is that.
 
Scott Selikoff
author
Saloon Keeper
Posts: 4014
18
Eclipse IDE Flex Google Web Toolkit
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
nikil shar wrote:i found that if i insert a row without the BLOB and then update it with the BLOB it works fine !!! how strange is that.


Actually that's normal for BLOB insertion. I've seen it most often in Oracle systems.
 
nikil shar
Ranch Hand
Posts: 116
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
do you know why it works that way ??
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic