Insert a BLOB using OracleXe
506605Apr 16 2006 — edited Apr 16 2006Hi!
I'm trying to put a BLOB into a db in OracleXE, but I get a error when execute the PreparedStatement with
"INSERT INTO informacioninstitucional (id_info_instit,descripcion,nombre_archivo) values (s_informacioninstitucional.nextvalue, ?,empty_blob())";
the error throwed is:
04:05:11,156 INFO [STDOUT] java.sql.SQLException: ORA-00984: columna no permitida aquí
04:05:11,156 INFO [STDOUT] at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
04:05:11,156 INFO [STDOUT] at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)
04:05:11,156 INFO [STDOUT] at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288)
04:05:11,171 INFO [STDOUT] at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:743)
04:05:11,171 INFO [STDOUT] at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:216)
04:05:11,265 INFO [STDOUT] at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:955)
04:05:11,265 INFO [STDOUT] at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1168)
04:05:11,265 INFO [STDOUT] at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3285)
04:05:11,265 INFO [STDOUT] at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3368)
04:05:11,265 INFO [STDOUT] at org.jboss.resource.adapter.jdbc.WrappedPreparedStatement.executeUpdate(WrappedPreparedStatement.java:256)
04:05:11,281 INFO [STDOUT] at proyecto_uoct.dao.InfoInstitDAO.upArchivo(InfoInstitDAO.java:60)
---
...
...
i'm using jdk1.4....help please!!