1. What am i doing wrong here? ( Stored Procedure REF CURSOR Problem) coderanch.comHi All, I have a stored procedude that has a REF CURSOR as its out parameter. Here is the code that I am trying: -------------------------------------- conn = dbUtil.getConnection(); stmt = conn.prepareCall( "{call P_ZEL_REPORTING.PAGE_SENT(?,?)}"); stmt.registerOutParameter(1, OracleTypes.CURSOR); stmt.setString(2, monthYear); stmt.execute(); ResultSet rs = (ResultSet)stmt.getObject(1); ------------------------------------------------- I get the following exception at runtime: SQLException: Unknown type: -10 I have checked everywhere, and it says ... |
2. Procedure returning Ref Cursor. coderanch.com |
3. Problems in fetching ref cursor. coderanch.comHi I am exeuting a Oracle stored proc which returns ref cursor. I have copule of problems with this. 1. Adter executing the proc..fetching the oupput from cursor is taking more time ..sometimes neary 1.5 hrs. Proc returns bulk data.Is there any way to make it fast. My code is like this. rs = ((OracleCallableStatement)cs).getCursor(2); while(rs.next()){ //statements to get column values. ... |
4. REF_CURSOR as IN parameter? coderanch.comHi, I have a stored procedure in Oracle which takes an input as a REF_CURSOR. What I am intending to to from java is pass an Array of Objects which has the 2 values in each object the stored procedure is trying to break and insert. Till now I have not been able to find the correct datatype to send to ... |
5. How do I print out the associate fields of a ref cursor? coderanch.com |
6. Calling Remote DB Stored Procedure which returns Ref Cursor coderanch.com |
7. java.sql.SQLException: Ref cursor is invalid coderanch.comHi all, please help in this error. cst = conx.prepareCall("call OFFNAMES_READ(?,?,?,?)"); cst.registerOutParameter(2, oracle.jdbc.driver.OracleTypes.CURSOR); cst.registerOutParameter(3, java.sql.Types.INTEGER); cst.registerOutParameter(4, java.sql.Types.INTEGER); cst.setInt(1, officeCod); cst.execute(); hash = new HashMap(); both = new ArrayList(); int officeCode = 0; String officeName = null; String officeType = null; if(cst.getObject(2)!=null){ Object officeInfoRes = cst.getObject(2); here htis problem is getting ava.sql.SQLException: Ref cursor is invalid 19:06:56,670 ERROR [STDERR] at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134) 19:06:56,670 ... |
8. Mapping ref cursor to java.sql.Types forums.oracle.com |