ORA-01460: unimplemented or unreasonable conversion requested

[nikil shar]

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.

byte[] bill = //read pdf doco

  String sql = "INSERT INTO BILL (ID, \"ACCOUNT_NO\", \"BILL_DATE\", 
\"DATE_CREATED\", PDF, ISPREGENERATED) values (SEQ_BILL.nextVal , '" 
+ accountNo.trim() + "', TO_DATE('" + billDate.trim() + "', 'DD/MM/YYYY'), sysdate, ? , '" 
+ preGenerated + "')";

            ps = this.conn.prepareStatement(sql);


            if (bill != null && bill.length > 0) {

                is = new ByteArrayInputStream(bill);
                 ps.setBinaryStream(1, is, bill.length);

            } else {
                Log.log(Level.INFO, "bill was empty.");
            }
            // ps.setBinaryStream(1, new ByteArrayInputStream(bill), bill.length);

            int result = ps.executeUpdate();

have verified that the sql works without the BLOB type.

any ideas what could be wrong ??



ta.

[Jeanne Boyarsky]

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]

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]

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]

do you know why it works that way ??