Oracle FAQ Your Portal to the Oracle Knowledge Grid

Home -> Community -> Usenet -> c.d.o.server -> Re: A PL/SQL Loop Question

Re: A PL/SQL Loop Question

From: <>
Date: Wed, 07 Nov 2007 12:21:58 -0800
Message-ID: <>

On Nov 7, 2:19 pm, wrote:
> 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 multi-
> dimentional 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

I apologize for the double post, but I also forgot to mention that the conditions for the WHERE clause are also coming in as an array. So, I'll need to construct my WHERE clause with an unknown number of elements. This part I've completed. It is just the storing of the data in the array and the proper loop I am having trouble with.

Thank you,

John Received on Wed Nov 07 2007 - 14:21:58 CST

Original text of this message