aspose file tools*
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 Java 8 in Action this week in the Java 8 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: 29275
    
140

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: 3697
    
    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 ??
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: ORA-01460: unimplemented or unreasonable conversion requested
 
Similar Threads
Error: Connection got Reset
reading BLOB type
storing BLOB type in oracle db
servlet not displaying all the pages in PDF
java.lang.AbstractMethodError