|Home |Login |Registration |Struts Step by Step Tutorial |Hibernate Step by Step Tutorial |Spring Step by Step Tutorial |JSP Step by Step Tutorial |JDBC Step by Step Tutorial |Web Services Step by Step Tutorial |EJB fundamentals | ORACLE Step by Step Tutorial | SCJP 5.0 and SCJP 6.0 Study Guide | SCWCD 5.0 Study Guide | SCJP Tips
Java mock test | SCJP mock test | SCJP DUMP | SCBCD mock test |Java online test exam | JSP online test | ORACLE online test | Hibernate online test | Servlet online test | Struts online test | EJB online test | C online test | C++ online test | Aptitude online test

Java interview questions | JSP interview questions | ORACLE interview questions | Hibernate interview questions | Servlet interview questions | Struts interview questions | JDBC interview questions | C/C++ interview questions | Spring interview questions | JMS interview questions | Informatica interview questions | EJB interview questions | OOPS and Design Pattern interview questions
1600 PMP mock questions 1400 CAPM mock questions 800 SCJP 6 mock questions 600 OCAJP 7 mock questions 590 OCPJP 7 mock questions 556 SCWCD 5 mock questions 500 OCEJWCD 6 mock questions pdfDownload (java,struts, hibernet etc) JobsJobs and Walkins

Java online test
JSP online test
ORACLE online test
Hibernate online test
Servlet online test
Struts online test
EJB online test
C online test
C++ online test
Aptitude online test

Q. How JDBC work with REF CURSOR returned by stored procedure and retrive results?

REF CUSROR is retrieved by the JDBC program
into a ResultSet.
Example code : This will help you.
Using regular CallableStatement :
CallableStatement cstmt = null;
ResultSet rset = null;
cstmt = con.prepareCall(
"{? = call ref_cursor_package.get_ref_cursor(?)}"
);
cstmt.registerOutParameter(1, OracleTypes.CURSOR);
cstmt.setInt(2, 104);
cstmt.execute();

rset = (ResultSet) cstmt.getObject(1);

while (rset.next()) {
System.out.println(
" - " +
rset.getString(2) + " (" + rset.getInt(1) + "), " +
rset.getString(3)
);
}


Using OracleCallableStatement and OracleResultSet classes:

OracleCallableStatement oraCallStmt = null;
OracleResultSet deptResultSet = null;
oraCallStmt = (OracleCallableStatement) con.prepareCall(
"{? = call ref_cursor_package.get_dept_ref_cursor(?)}"
);
oraCallStmt.registerOutParameter(1, OracleTypes.CURSOR);
oraCallStmt.setInt(2, 104);
oraCallStmt.execute();

deptResultSet = (OracleResultSet) oraCallStmt.getCursor(1);

while (deptResultSet.next()) {
System.out.println(
" - " +
deptResultSet.getString(2) + " (" + deptResultSet.getInt(1) + "), " +
deptResultSet.getString(3)
);
}

Suggested Jobs

   More Jobs >>

Online Practice Test

Java online test
JSP online test
ORACLE online test
Hibernate online test
Servlet online test
Struts online test
EJB online test
C online test
C++ online test
Aptitude online test

The information you are posting should be related to java and ORACLE technology. Not political.