Granny's Programming Pearls
"inside of every large program is a small program struggling to get out"
JavaRanch.com/granny.jsp
  • Post Reply Bookmark Topic Watch Topic
  • New Topic

ORA-01460: unimplemented or unreasonable conversion requested  RSS feed

 
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: 37181
515
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
Bartender
Posts: 4087
21
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 ??
 
Consider Paul's rocket mass heater.
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!