Oracle - ora

 
Vista:

ora

Publicado por mirdch (2 intervenciones) el 12/07/2007 15:51:14
BEGIN INSERT INTO viajar_address_data(ADD_ID_ADDRESS,ADT_ID_ADDRESSTYPE,ADD_CITY,ADD_REGION,ADD_STREET,ADD_NUMBER,ADD_FLOOR,ADD_STAIR,ADD_LETTER,ADD_BLOCK,ADD_DOORWAY,ADD_COMPANY,ADD_ZIP_CODE,VIAJAR_PROVINCE_ID,VIAJAR_COUN_ISO2) VALUES(add_id_address_seq.nextval,?,?,?,?,?,?,?,?,?,?,?,?,?,?) ; END;
java.sql.SQLException: ORA-01008: not all variables bound

at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
at oracle.jdbc.oci8.OCIDBAccess.check_error(OCIDBAccess.java:2355)
at oracle.jdbc.oci8.OCIDBAccess.executeFetch(OCIDBAccess.java:1760)
at oracle.jdbc.oci8.OCIDBAccess.parseExecuteFetch(OCIDBAccess.java:1921)
at oracle.jdbc.driver.OracleStatement.executeNonQuery(OracleStatement.java:2191)
at oracle.jdbc.driver.OracleStatement.doExecuteOther(OracleStatement.java:2064)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:2989)
at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:658)
at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:101)
at com.openjaw.database.OracleJdbcWrapper.executeInsert(OracleJdbcWrapper.java:713)
at com.openjawx.dbInterface.DBMessageProcessor.insertInToDB(DBMessageProcessor.java:588)
at com.openjawx.dbInterface.DBMessageProcessor.processTransactions(DBMessageProcessor.java:329)
at com.openjawx.dbInterface.DBMessageProcessor.process(DBMessageProcessor.java:168)
at com.openjaw.serviceProvider.JavaConnectorBase.process(JavaConnectorBase.java:80)
at com.openjaw.serviceProvider.JavaConnection.processMessage(JavaConnection.java:102)
at com.openjaw.serviceProvider.ServerThread.run(ServerThread.java:335)
at java.lang.Thread.run(Thread.java:595)
2007-07-09 07:54:46,080 [Supplier_GDBC_2] - Exception in insert: ORA-08002: sequence ADD_ID_ADDRESS_SEQ.CURRVAL is not yet defined in this session
ORA-06512: at line 1

No comprendo el error que me esta dando
Valora esta pregunta
Me gusta: Está pregunta es útil y esta claraNo me gusta: Está pregunta no esta clara o no es útil
0
Responder