Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Convert table to cursor in stored proc
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
![]() |
![]() |