Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Convert table to cursor in stored proc

Convert table to cursor in stored proc

From: <tomjt1_at_my-deja.com>
Date: 2000/05/03
Message-ID: <8eq3o7$sna$1@nnrp1.deja.com>#1/1

I've got a fairly complicated stored procedure that builds a table of records. I want to return this table to my Java program. Is there a way to do this? Can I convert the table to a cursor somehow?

TIA, Tom

For clarification:
My procedure creates a type based on my 'task' table..   TYPE T_TABLE_ARRAY IS TABLE OF task%ROWTYPE INDEX BY BINARY_INTEGER; My result array is
  v_result T_TABLE_ARRAY;

At the end of my procedure, I've filled v_result with a lot of records. Ideally, I'd like to cast this somehow into a cursor that can be parsed by my Java app. It's seems unlikely that the JDBC would translate my PL/SQL table into a valid Java object.

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Wed May 03 2000 - 00:00:00 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US