Originally posted by J. Alenis:
Yes I tried it this way:
String nasty= "'nn>''111111111111''')";
crs.setString(3,nasty);
crs.setCommand("Call DB.STOPRO(?,?,");
crs.execute();
When I put the setString after the setCommand I get:
java.sql.SQLException: missing parameter: 1
SCJA,SCJP,SCWCD,SCBCD,SCEA I
Java Developer, Thailand
SCJA,SCJP,SCWCD,SCBCD,SCEA I
Java Developer, Thailand
SQL -440: No authorized routine named routine-name of type routine-type having compatible arguments was found.
SCJA,SCJP,SCWCD,SCBCD,SCEA I
Java Developer, Thailand
SCJA,SCJP,SCWCD,SCBCD,SCEA I
Java Developer, Thailand
Did you see how Paul cut 87% off of his electric heat bill with 82 watts of micro heaters? |