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?
Pratap wrote:
> I assume that your Java procedure is working on some huge data in the
> database, and then generating a set of rows that you want to pass on
> to PL/SQL.
> From Java you can batch insert the data in a temporary table. PL/SQL
> can then read this table. The insert overhead in the temporary table
> will be very less.
>
> If you are using Oracle 9i you may use pipelined functions can also be
> used as they they can be written in Java. But I don't know much about
> Java.
>
> Pratap
Sounds like what I need, except I can't find in Oracle's documentation the Java equivalent of the PL/SQL "PIPE ROW" statement. You say pipelined functions can be written in Java... do you have any pointers to documentation?
Thanks
Jim Garrison
jhg_at_athensgroup.com
Received on Thu Sep 02 2004 - 14:10:38 CDT