Re: Create ResultSet "from scratch" in Oracle Java Stored Procedure?
Date: Thu, 02 Sep 2004 14:10:38 -0500
Message-ID: <4137702E.3060107_at_athensgroup.com>
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 - 21:10:38 CEST