oracle.jdbc.driver.OracleSQLException: ORA-01008
hi, i have a prob when i try to insert data from java stored procedure. My source is next:
connection =new OracleDriver().defaultConnection();
...
sql ="INSERT INTO TMP_TELPU (TMPCAD) VALUES(?)";
pstmt = connection.prepareStatement(sql);
pstmt.setString(1,line);
pstmt.executeUpdate(sql);
connection.commit();
...
But, when i run it, this generate the next exception:
oracle.jdbc.driver.OracleSQLException: ORA-01008: no todas las variables han sido enlazadas
at oracle.jdbc.driver.T2SConnection.check_error(T2SConnection.java:148)
at oracle.jdbc.driver.T2SPreparedStatement.checkError(T2SPreparedStatement.java:92)
at oracle.jdbc.driver.T2SPreparedStatement.executeForRows(T2SPreparedStatement.java:449)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1292)
at oracle.jdbc.driver.OracleStatement.executeUpdateInternal(OracleStatement.java:1872)
at oracle.jdbc.driver.OracleStatement.executeUpdate(OracleStatement.java:1837)
at StreamGobbler.run(STRGOB:58)
Tanks!!!.
