Win a copy of The Java Performance Companion this week in the Performance 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: 34681
367
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: 4015
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