Syntax Error : Malformed SQL92

I got error

java.sql.SQLException: Malformed SQL92 string at position: 53

What is that? Not sure.Headache.Then I stare at the code..deeply

cStmt = con.prepareCall("call MYPACKAGE.MYPROCEDURE(?)}");

Nah..see the cause?
cStmt = con.prepareCall("call MYPACKAGE.MYPROCEDURE(?)}");

Now you see... the correct version should be like this.

cStmt = con.prepareCall("{call MYPACKAGE.MYPROCEDURE(?)}");

Simple '{' can make my life haywire.My clumsiness cannot be helped!

Comments

Popular Posts