Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Create ResultSet "from scratch" in Oracle Java Stored Procedure?

Create ResultSet "from scratch" in Oracle Java Stored Procedure?

From: Jim Garrison <jhg_at_athensgroup.com>
Date: Wed, 01 Sep 2004 12:10:05 -0500
Message-ID: <ApSdnatW99D-n6vcRVn-gw@giganews.com>


I need to create a ResultSet in an Oracle Java Stored Procedure and return it to a PL/SQL caller. I've done quite a bit of research in Oracle's manuals and on the Web, and have found lots of references to going the other direction (PL/SQL passing/returning REF CURSOR to Java), and Java returning an existing ResultSet (obtained from the databse) as a REF CURSOR to PL/SQL. Neither of these is what I'm looking for.

My Java stored procedure will do significant data reduction on a large database, and then needs to return a large result set to the caller, which will be in PL/SQL. To the PL/SQL caller, the Java stored procedure needs to look like a "table function", but I need to create the result set from scratch in my Java code. What I think I need is a documented skeleton ResultSet implementation that I can extend.

Anyone know if this is available anywhere, or have pointers to documentation?

Jim Garrison
jhg_at_athensgroup.com Received on Wed Sep 01 2004 - 12:10:05 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US