Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> 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