stored proc returning array

[Michael Trosen]

Hi Everyone,

I hope someone can help, I'm pretty new to pro*c programming.

I have the following application setup:

a pro*c program calls a stored procedure and recieves a cursor back:

the cursor is defined as: SQL_CURSOR delpt_cursor

it's assigned by:
:delpt_cursor := radixbrc.retMMA ddrsList(:zip,: RtNum,:ih_date)

So, now I have all the data that was retrieved in the stored procedure
in a cursor, and I can loop through it:

for (;;)
{
get each piece of data
put data in flat file
}

The problem with this approach is that it is too slow..

So, i'm looking at instead of returning a cursor, returning a host
array... does it make sense to do this instead? If so, how do you get
the data out of the host array in the Pro*C code?

Thank you for any help!!

Michael