Oracle sucks once again

If you are using iBatis SqlMaps and execute a stored procedure, you should probably not format the SQL string, e.g.:

<procedure id="exec" parameterClass="org.example.Param">
 {
      call p_main (
              #param1:NUMERIC#,
              #param2:DATE# )
 }
</procedure>

java.sql.SQLException: Non supported SQL92 token at position: 4:
        at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
        at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:146)
        at oracle.jdbc.driver.OracleSql.handleToken(OracleSql.java:1165)
        at oracle.jdbc.driver.OracleSql.handleODBC(OracleSql.java:1064)
        at oracle.jdbc.driver.OracleSql.parse(OracleSql.java:984)
        at oracle.jdbc.driver.OracleSql.getSql(OracleSql.java:312)
        at oracle.jdbc.driver.OracleSql.getSqlBytes(OracleSql.java:557)

The solution: remove TABS and newlines from the SQL in the procedure call.

• Comment (1)
• Trackbacks (0)