Re: PL/SQL tables to reference cursors

Brian,

I know that you can bind the values of a pl/sql table to a host array with Pro*C. Maybe you should try that approach instead (if you know C and have Pro*C).

Alternativly, maybe you could clooge (spelling?) something together with pl/sql so that you create a cursor that selects the pl/sql table data against dual into your cursor. I have to believe that this method will be awfully clunky.

Hope this helps,

SCott

vick9935_at_my-dejanews.com wrote:

> 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 Thu Jul 23 1998 - 15:21:44 CDT