|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

 

Recent Questions

!!! JDBC Frequently Asked Questions !!!

Q.How to retrive the results in java returned by refcursor in Stored procedure ?

SCJP 1.5/1.6 Exam Kit

!!!Answer!!!- From Technical Expert

In the Stored procedure :
create procedure emp_details () return refcursor as '
declare
empref refcursor;
begin
open empref for
SELECT emp.name,emp.age
FROM emp;
return empref;
end;

In the Java Code :

Connection con = null;
CallableStatement cstmt = null;
try
{
con = ConnectionPool.getConnection();

con.setAutoCommit(false);

// Setup the call.
cstmt = connection.prepareCall("{ ? = call emp_details () }");
// you can use
cstmt = connection.prepareCall("{call emp_details (?) }");

cstmt.registerOutParameter(1, OracleTypes.CURSOR);
cstmt.execute();

ResultSet rs = (ResultSet)cstmt.getObject(1);
while (rs.next())
{
String name = rs.getString(1);
int age = rs.getInt(2);
}
rs.close();
}
catch (SQLException e)
{
cstmt.close();
con.close();
}

Answered By : null Replied Date : Mar 29 2012
Answer :


Answered By : null Replied Date : Mar 28 2012
Answer :


Answered By : null Replied Date : Mar 26 2012
Answer :


Answered By : null Replied Date : Mar 26 2012
Answer :


Answered By : null Replied Date : Mar 25 2012
Answer :


Answered By : null Replied Date : Mar 23 2012
Answer :


Answered By : null Replied Date : Mar 21 2012
Answer :


Answered By : null Replied Date : Mar 20 2012
Answer :


Answered By : null Replied Date : Mar 19 2012
Answer :


Answered By : null Replied Date : Mar 16 2012
Answer :


Answered By : null Replied Date : Mar 15 2012
Answer :


Answered By : null Replied Date : Mar 12 2012
Answer :


Answered By : null Replied Date : Mar 11 2012
Answer :


Answered By : null Replied Date : Mar 11 2012
Answer :


Answered By : null Replied Date : Mar 7 2012
Answer :


Answered By : null Replied Date : Mar 5 2012
Answer :


Answered By : null Replied Date : Mar 5 2012
Answer :


Answered By : null Replied Date : Mar 3 2012
Answer :


Answered By : null Replied Date : Mar 3 2012
Answer :


Answered By : null Replied Date : Mar 2 2012
Answer :


Answered By : null Replied Date : Mar 1 2012
Answer :


Answered By : null Replied Date : Feb 27 2012
Answer :


Answered By : null Replied Date : Feb 25 2012
Answer :


Answered By : null Replied Date : Feb 23 2012
Answer :


Answered By : null Replied Date : Feb 22 2012
Answer :


Answered By : null Replied Date : Feb 7 2012
Answer :


Answered By : null Replied Date : Feb 7 2012
Answer :


Answered By : null Replied Date : Jan 26 2012
Answer :


Answered By : null Replied Date : Jan 26 2012
Answer :


Answered By : null Replied Date : Jan 24 2012
Answer :


Answered By : null Replied Date : Jan 11 2012
Answer :


Answered By : null Replied Date : Dec 27 2011
Answer :


Answered By : null Replied Date : Dec 5 2011
Answer :


Answered By : null Replied Date : Dec 5 2011
Answer :


Answered By : null Replied Date : Dec 3 2011
Answer :


Answered By : null Replied Date : Dec 2 2011
Answer :


Answered By : null Replied Date : Dec 1 2011
Answer :


Answered By : null Replied Date : Nov 26 2011
Answer :


Answered By : null Replied Date : Nov 19 2011
Answer :


Answered By : null Replied Date : Nov 15 2011
Answer :


Answered By : null Replied Date : Nov 15 2011
Answer :


Answered By : null Replied Date : Nov 12 2011
Answer :


Answered By : null Replied Date : Nov 8 2011
Answer :


Answered By : null Replied Date : Nov 4 2011
Answer :


Answered By : null Replied Date : Nov 1 2011
Answer :


Answered By : null Replied Date : Oct 28 2011
Answer :


Answered By : null Replied Date : Oct 27 2011
Answer :


Answered By : null Replied Date : Oct 27 2011
Answer :


Answered By : null Replied Date : Oct 24 2011
Answer :


Answered By : null Replied Date : Oct 24 2011
Answer :


Answered By : null Replied Date : Oct 19 2011
Answer :


Answered By : null Replied Date : Sep 27 2011
Answer :


Answered By : null Replied Date : Sep 15 2011
Answer :


Answered By : null Replied Date : Sep 5 2011
Answer :


Answered By : null Replied Date : Sep 3 2011
Answer :


Answered By : null Replied Date : Sep 2 2011
Answer :


Answered By : null Replied Date : Aug 9 2011
Answer :


Answered By : null Replied Date : Jul 11 2011
Answer :


Answered By : null Replied Date : Jun 20 2011
Answer :


Answered By : null Replied Date : Jun 17 2011
Answer :


Answered By : null Replied Date : Jun 4 2011
Answer :


Answered By : null Replied Date : May 14 2011
Answer :


Answered By : null Replied Date : Apr 7 2011
Answer :


Answered By : null Replied Date : Apr 7 2011
Answer :


Answered By : null Replied Date : Apr 6 2011
Answer :


Answered By : null Replied Date : Mar 29 2011
Answer :


Answered By : null Replied Date : Mar 11 2011
Answer :


Answered By : null Replied Date : Jan 27 2011
Answer :


Answered By : null Replied Date : Jan 20 2011
Answer :


Answered By : null Replied Date : Jan 19 2011
Answer :


Answered By : null Replied Date : Jan 15 2011
Answer :


Answered By : null Replied Date : Jan 13 2011
Answer :


Answered By : null Replied Date : Jan 9 2011
Answer :


Answered By : null Replied Date : Nov 21 2010
Answer :


Answered By : null Replied Date : Nov 17 2010
Answer :


Answered By : null Replied Date : Nov 16 2010
Answer :


Answered By : null Replied Date : Nov 10 2010
Answer :


Answered By : null Replied Date : Nov 8 2010
Answer :


Answered By : null Replied Date : Nov 1 2010
Answer :


Answered By : null Replied Date : Aug 27 2010
Answer :


Answered By : null Replied Date : Aug 19 2010
Answer :


Answered By : null Replied Date : Aug 18 2010
Answer :


Answered By : null Replied Date : Aug 15 2010
Answer :


Answered By : null Replied Date : Aug 10 2010
Answer :


Answered By : null Replied Date : Jun 2 2012
Answer :


Answered By : null Replied Date : Jun 3 2012
Answer :


Answered By : null Replied Date : Jun 9 2012
Answer :


Answered By : null Replied Date : Jun 29 2012
Answer :


Answered By : null Replied Date : Jul 4 2012
Answer :


Answered By : null Replied Date : Jul 6 2012
Answer :


Answered By : null Replied Date : Jul 22 2012
Answer :


Answered By : null Replied Date : Jul 28 2012
Answer :


Answered By : null Replied Date : Aug 4 2012
Answer :


Answered By : null Replied Date : Aug 6 2012
Answer :


Answered By : null Replied Date : Aug 14 2012
Answer :


Answered By : null Replied Date : Aug 31 2012
Answer :


Answered By : null Replied Date : Sep 7 2012
Answer :


Answered By : null Replied Date : Sep 8 2012
Answer :


Answered By : null Replied Date : Sep 8 2012
Answer :


Answered By : null Replied Date : Sep 15 2012
Answer :


Answered By : null Replied Date : Sep 18 2012
Answer :


Answered By : null Replied Date : Sep 20 2012
Answer :


Answered By : null Replied Date : Oct 10 2012
Answer :


Answered By : null Replied Date : Nov 2 2012
Answer :


Answered By : null Replied Date : Nov 29 2012
Answer :


Answered By : null Replied Date : Dec 8 2012
Answer :


Answered By : null Replied Date : Dec 9 2012
Answer :


Answered By : null Replied Date : Jan 7 2013
Answer :


Answered By : null Replied Date : Jan 31 2013
Answer :


Answered By : null Replied Date : Feb 18 2013
Answer :


Answered By : null Replied Date : Feb 22 2013
Answer :


 

You can also contribute to this answer:

Your Name:
Answer:

 
Ask Question and get answer from Expert.
View Answers List from Expert.

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