Re: Facing problem with CallableStatement

Hi steve,
Thanks for you response.
still iam getting another error. Can you please look into this....

now the code is: cstmt.registerIndexTableOutParameter(4, maxLen, OracleTypes.VARCHAR, elemMaxLen);

the new error is:
5/9/06 3:14 AM: java.sql.SQLException: Unsupported feature 5/9/06 3:14 AM: at
oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:185) 5/9/06 3:14 AM: at
oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:227) 5/9/06 3:14 AM: at
oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:290) 5/9/06 3:14 AM: at
oracle.jdbc.dbaccess.DBDataSet.checkPlsqlIndexTableBindTypes(DBDataSet.java:687) 5/9/06 3:14 AM: at
oracle.jdbc.driver.OraclePreparedStatement.checkPlsqlIndexTableBindTypes(OraclePreparedStatement.java:2865) 5/9/06 3:14 AM: at
oracle.jdbc.driver.OracleCallableStatement.registerIndexTableOutParameter(OracleCallableStatement.java:923) 5/9/06 3:14 AM: at
_secure._LocationQIP._jspService(_LocationQIP.java:197) 5/9/06 3:14 AM: at
com.orionserver.http.OrionHttpJspPage.service(OrionHttpJspPage.java:56) 5/9/06 3:14 AM: at
oracle.jsp.runtimev2.JspPageTable.compileAndServe(JspPageTable.java:508) 5/9/06 3:14 AM: at
oracle.jsp.runtimev2.JspPageTable.service(JspPageTable.java:255) 5/9/06 3:14 AM: at
oracle.jsp.runtimev2.JspServlet.internalService(JspServlet.java:407) 5/9/06 3:14 AM: at
oracle.jsp.runtimev2.JspServlet.service(JspServlet.java:330) 5/9/06 3:14 AM: at
javax.servlet.http.HttpServlet.service(HttpServlet.java:336) 5/9/06 3:14 AM: at
com.evermind.server.http.ServletRequestDispatcher.invoke(ServletRequestDispatcher.java:684) 5/9/06 3:14 AM: at
com.evermind.server.http.ServletRequestDispatcher.forwardInternal(ServletRequestDispatcher.java:269) 5/9/06 3:14 AM: at
com.evermind.server.http.HttpRequestHandler.processRequest(HttpRequestHandler.java:735) 5/9/06 3:14 AM: at
com.evermind.server.http.HttpRequestHandler.run(HttpRequestHandler.java:243) 5/9/06 3:14 AM: at
com.evermind.util.ThreadPoolThread.run(ThreadPoolThread.java:64)

Thanks in advance.

Thanks & Regards,
Suresh T. Received on Tue May 09 2006 - 04:30:00 CDT