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.retMMAddrsList(: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?
