XPost: comp.lang.java.databases, comp.databases.oracle.server   
   From: kennedy-downwithspammersfamily@attbi.net   
      
   "Jim Garrison"  wrote in message   
   news: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@athensgroup.com   
   Did you look at the pipelined property of a function?   
   Jim   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)