int test_id = 1;
String sqlQuery = "INSERT INTO
test (test_ID,text) VALUES (?,'sometext')";
PreparedStatement prepstmt = dbConnection.prepareStatement(sqlQuery);
prepstmt.setInt(1,test_id);
WORKS FINE
********************************************************************************************
int test_id = 1;
String text = "sometext";
String sqlQuery = "INSERT INTO test (test_ID,text) VALUES (?,'?')";
PreparedStatement prepstmt = dbConnection.prepareStatement(sqlQuery);
prepstmt.setInt(1,test_id);
prepstmt.setString(2,text);
ERROR : ORA-01006: bind variable does not exist
********************************************************************************************
String text = "sometext";
String sqlQuery = "INSERT INTO test (test_ID,text) VALUES (1,'?')";
PreparedStatement prepstmt = dbConnection.prepareStatement(sqlQuery);
prepstmt.setString(2,text);
ERROR : ORA-17041 Missing IN or OUT parameter at index
********************************************************************************************
Can any one give me hints of why this happens ??
Thanks in advance...
Regards,
Bhiku
[ May 07, 2003: Message edited by: Bhiku Mhatre ]