OTRO CASO como el de antes , necesito un poco de iluminacion
BEGIN INSERT INTO VIAJAR_FLIGHT_RESERVATION(RES_ID_RESERVATION,FLR_O NEWAY,FLR_ADULT_BASE_PRICE,FLR_ADULT_TAXES_PRICE,F LR_CHILD_BASE_PRICE,FLR_CHILD_TAXES_PRICE,FLR_INFA NT_BASE_PRICE,FLR_INFANT_TAXES_PRICE,FLR_SENIOR_BA SE_PRICE,FLR_SENIOR_TAXES_PRICE,FLR_LAST_TICKETING _DATE,FLR_SEPARATE_FARES,FLR_RULE_NOADMIT,FLR_RULE _COMMENTS,FLR_RULE_PAYMENT_LIMIT,FLR_RESIDENT,FLR_ PRIVATE_FARE,FLR_TIJERETAZO,FLR_MARKET) VALUES(RES_ID_RESERVATION_SEQ.currval,?,?,?,?,?,?, ?,?,?,?,?,?,?,?,?,?,?,?) ; END;
java.sql.SQLException: ORA-01722: invalid number
ORA-06512: at line 1
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBE rror.java:134)
at oracle.jdbc.oci8.OCIDBAccess.check_error(OCIDBAcce ss.java:2355)
at oracle.jdbc.oci8.OCIDBAccess.executeFetch(OCIDBAcc ess.java:1760)
at oracle.jdbc.oci8.OCIDBAccess.parseExecuteFetch(OCI DBAccess.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.doExecuteWithTi meout(OracleStatement.java:2989)
at oracle.jdbc.driver.OraclePreparedStatement.execute Update(OraclePreparedStatement.java:658)
at org.apache.commons.dbcp.DelegatingPreparedStatemen t.executeUpdate(DelegatingPreparedStatement.java:1 01)
at com.openjaw.database.OracleJdbcWrapper.executeInse rt(OracleJdbcWrapper.java:713)
at com.openjawx.dbInterface.DBMessageProcessor.insert InToDB(DBMessageProcessor.java:588)
at com.openjawx.dbInterface.DBMessageProcessor.proces sTransactions(DBMessageProcessor.java:329)
at com.openjawx.dbInterface.DBMessageProcessor.proces s(DBMessageProcessor.java:168)
at com.openjaw.serviceProvider.JavaConnectorBase.proc ess(JavaConnectorBase.java:80)
at com.openjaw.serviceProvider.JavaConnection.process Message(JavaConnection.java:102)
at com.openjaw.serviceProvider.ServerThread.run(Serve rThread.java:335)
at java.lang.Thread.run(Thread.java:595)
2007-07-16 11:16:31,241 [Supplier_GDBC_7] - Exception in insert: ORA-02291: integrity constraint (VIAJARADM.FK_SEGMENT_RELATION_FLIGHT) violated - parent key not found
ORA-06512: at line 1
Cómo hacer preguntas de manera inteligente
