This week's book giveaways are in the Java EE and JavaScript forums.
We're giving away four copies each of The Java EE 7 Tutorial Volume 1 or Volume 2(winners choice) and jQuery UI in Action and have the authors on-line!
See this thread and this one for details.
The moose likes JDBC and the fly likes ORA-01460: unimplemented or unreasonable conversion requested Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of The Java EE 7 Tutorial Volume 1 or Volume 2 this week in the Java EE forum
or jQuery UI in Action in the JavaScript forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "ORA-01460: unimplemented or unreasonable conversion requested" Watch "ORA-01460: unimplemented or unreasonable conversion requested" New topic
Author

ORA-01460: unimplemented or unreasonable conversion requested

nikil shar
Ranch Hand

Joined: May 25, 2008
Posts: 116
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
internet detective
Marshal

Joined: May 26, 2003
Posts: 30355
    
150

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?


[Blog] [JavaRanch FAQ] [How To Ask Questions The Smart Way] [Book Promos]
Blogging on Certs: SCEA Part 1, Part 2 & 3, Core Spring 3, OCAJP, OCPJP beta, TOGAF part 1 and part 2
nikil shar
Ranch Hand

Joined: May 25, 2008
Posts: 116
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
Saloon Keeper

Joined: Oct 23, 2005
Posts: 3704
    
    5

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.


My Blog: Down Home Country Coding with Scott Selikoff
nikil shar
Ranch Hand

Joined: May 25, 2008
Posts: 116
do you know why it works that way ??
 
With a little knowledge, a cast iron skillet is non-stick and lasts a lifetime.
 
subject: ORA-01460: unimplemented or unreasonable conversion requested