HELP: PRO*C/STORED PROCEDURE/Return list of rows

Greetings,

We have a problem using Pro*C and Oracle Stored Procedure to retrieve a list of records out of a database. The problem is being that we declared a fix-sized array for the host variable to receive the query result from our stored procedure. But obviously it won't work if the query result is larger than the array size.

My question is: Is there a way to dynamically allocate memory in the application code to get query result back from the stored procedure?

To me, it should be a typical problem in any database application development. Any idea of how to tackle this?

Thanks,

Hongwen Zhu Received on Thu Feb 02 1995 - 02:07:54 CET