Java Database Connectivity (JDBC)

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Fetch absolute possible with JDBC 2 but with PL/SQL ?

204617Jun 26 2002

Oracle permits absolute (or prior) result set positionning through JDBC 2.
How can I declare such a cursor in Oracle 8i PL/SQL (8.1.7) ?

In fact, I want (I have to ...) to create a scrollable cursor in a PL/SQL stored procedure and return it to a Java Application through JDBC 2.
This Java Application may then use absolute positionning requests ( myResultSet.absolute(pos) ).

If Oracle 8i does it for JDBC 2 (I tested it successfully), it can do it for PL/SQL ? (I guess)

I have also read that Rdb7 SQL does it natively.

Locked Post

New comments cannot be posted to this locked post.

Locked on Jul 24 2002

Added on Jun 26 2002

#java-database-connectivity-jdbc

0 comments

249 views