Using Blob in Databases

From: will <belwill_at_singnet.com.sg>
Date: Wed, 23 Feb 2000 14:54:11 +0800
Message-ID: <38B38413.B949B171@singnet.com.sg>

Hello there . Anyone knows how to put a inputstream into a blob field using JDBC ??
I tried using setBytes and setBinaryStream but they crashed on me giving me an exception like this:
Exception in thread "main" java.sql.SQLException: ORA-01461: can bind a LONG val
ue only for insert into a LONG column

        at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:208)
        at oracle.jdbc.ttc7.Oall7.receive(Oall7.java, Compiled Code)
        at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1249)

        at
oracle.jdbc.ttc7.TTC7Protocol.parseExecuteFetch(TTC7Protocol.java:685)
        at

oracle.jdbc.driver.OracleStatement.doExecuteOther(OracleStatement.java:781)

        at
oracle.jdbc.driver.OracleStatement.doExecuteWithBatch(OracleStatement.java:823)

        at
oracle.jdbc.driver.OracleStatement.doExecute(OracleStatement.java:1165)

        at
oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1211)

        at
oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:97)

        at test_db.main(test_db.java:33) .
Thanks in advance. Received on Wed Feb 23 2000 - 00:54:11 CST