PL/SQL tables to reference cursors

From: <vick9935_at_my-dejanews.com>
Date: Tue, 21 Jul 1998 19:07:39 GMT
Message-ID: <6p2otq$45a$1@nnrp1.dejanews.com>

Provided we have the correct version of PL/SQL running against Oracle 7.3...such that it supports a "PL/SQL table of records"...is it possible to use a reference cursor to select from the table of records? What if the table of records is not based upon a table definition (dept%rowtype), but is instead based upon the columns of a select statement accessing multiple tables?

I ask this because:

1. I need to retrieve into the table of records and then manipulate the data
2. I do not want to create a temporary table with the manipulated results
3. My front end requires the data to come back in a reference cursor

Thanks for the help,

Brian in Seattle

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum Received on Tue Jul 21 1998 - 14:07:39 CDT