how to return The Cursor from the OracleProcedure

Discussions

General J2EE: how to return The Cursor from the OracleProcedure

  1. Hi
    I would like to get the Cursor from the Oracle Procedure
    Here is the Sameple
    That I am running from the java
    Resultset rs= select * from sample_table;


    The same query in the Procedure which is very fast and takes less time.
    So i need to return as Cursor where in java i need to get As the Resultset type

    So I hope anyone come across using this could help me out...

  2. try this link, it should help

    http://osi.oracle.com/~tkyte/ResultSets/index.html
  3. Thanks but I need the ConnectionLess Result set .After executing the procedure the connection should be closed and I nedd will work on the return result set...