Thursday, July 07, 2011

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!

No comments:

Post a Comment