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

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 Received on Wed Sep 01 2004 - 23:28:36 CDT