A PL/SQL Loop Question

Hi Everyone,

I have this weird thing I have to do in PL/SQL and cannot figure it out.

We are running 8i at the moment. I need to use dynamic SQL for this. Our application receives some parameters from a website. On the website the user will choose which columns of data they want to display. The information is received by the procedure via an array.

I need to go through each element of the array, using it's contents, and gather some data from a table, and then return the information back to PHP.

So, I have an unknown number of items that I need to select, as well as an unknown number of items which will be returned by the query.

My thought was to set up a 2 dimentional array and first loop through the number of items in the array. For each item I'd construct a select statement and retrieve the column from the table. So, I'd come up with an array that would have rows and columns of everything needed.

I was going to use 'EXECUTE IMMEDIATE' to execute the query. I am having trouble with 2 things: First is if Oracle 8i supports multidimentional  arrays. The second thing is since I do not know how many rows I am retrieving from the table, how can I construct the proper loop?

A weird thing and hard to explain. I can try to be more specific if needed.

Thank you.

John Received on Wed Nov 07 2007 - 14:19:57 CST