Ora-01008

at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)

at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:289)

at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:573)

at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1891)

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

at oracle.jdbc.driver.OracleStatement.executeNonQuery(OracleStatement.java:2047)

at oracle.jdbc.driver.OracleStatement.doExecuteOther(OracleStatement.java:1940)

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

at oracle.jdbc.driver.OracleStatement.executeUpdate(OracleStatement.java:796)

at TPESap.recordData(TPESap.java:90)

at TPESap.(TPESap.java:35)

at TPESap.main(TPESap.java:20)

public void recordData (String dados[][])

{

try

{ String query = “INSERT INTO provSAP ( NF, DTEMISSAO, CLFISCAL, VALUNITARIO, VALTOTAL, DOCVENDA, NRPEDIDO, NRITEM, SETOR, NOMECLIENTE, MATERIAL, QUANTIDADE, CODCLIENTE) VALUES ( ?, ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ?, ?)”;

PreparedStatement statement = conexao.prepareStatement(query);

for ( int linha = 0; linha <= dados.length; linha++)

{ statement.setString(1,dados[linha][0]);

statement.setString(2,dados[linha][1]);

statement.setString(3,dados[linha][2]);

statement.setString(4,dados[linha][3]);

statement.setString(5,dados[linha][4]);

statement.setString(6,dados[linha][5]);

statement.setString(7,dados[linha][6]);

statement.setString(8,dados[linha][7]);

statement.setString(9,dados[linha][8]);

statement.setString(10,dados[linha][9]);

statement.setString(11,dados[linha][10]);

statement.setString(12,dados[linha][11]);

statement.setString(13,dados[linha][12]);

//linha 90

int result = statement.executeUpdate(query);

System.out.println( result);

}

statement.close();

}

catch (SQLException sqlex )

{

sqlex.printStackTrace();

System.out.println( sqlex.toString() );

}

}