How invoke a PL/SQL Cursor from JSP?
I´need display a cursor in a table.
I have this.
CallableStatement cs = con.prepareCall("{call "+sentencia+"}"
;
cs.setString(1,"1283582"
cs.registerOutParameter(2,java.sql.Types.VARCHAR);
cs.registerOutParameter(3,java.sql.Types.VARCHAR);
cs.registerOutParameter(4,oracle.jdbc.driver.OracleTypes.CURSOR);
cs.execute();
I´need display a cursor in a table.
I have this.
CallableStatement cs = con.prepareCall("{call "+sentencia+"}"
;cs.setString(1,"1283582"
;cs.registerOutParameter(2,java.sql.Types.VARCHAR);
cs.registerOutParameter(3,java.sql.Types.VARCHAR);
cs.registerOutParameter(4,oracle.jdbc.driver.OracleTypes.CURSOR);
cs.execute();