Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> PL/SQL tables to reference cursors
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
![]() |
![]() |