Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Create ResultSet "from scratch" in Oracle Java Stored Procedure?
"Jim Garrison" <jhg_at_athensgroup.com> wrote in message
news:ApSdnatW99D-n6vcRVn-gw_at_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
Did you look at the pipelined property of a function?
Jim
Received on Wed Sep 01 2004 - 21:30:43 CDT