Re: Prepared statement within a stored procedure loop

From: Mark Plant <mplant_at_uk.oracle.com>
Date: Thu, 24 Jun 1999 16:44:41 GMT
Message-ID: <37726027.21808003@newshost.uk.oracle.com>

You need to look at the DBMS_SQL package which is documented (I think) in the PL/SQL User's Guide and Reference.

Mark

On Fri, 11 Jun 1999 23:31:08 GMT, mozkill_at_my-deja.com wrote:

>Does anyone have a rough idea of what the syntax for a prepared
>statement would be inside a loop of a stored procedure.
>
>Example:
>
>while x < 10
> preparedStatement = "SELECT label" + x + " FROM field" + x + " WHERE
>item = "somestring"
>execute(preparedstatement)
>end loop
>
>i realize the syntax above is all screwed up. any help would be
>appreciated, or a GOOD url. notice how the table and field element
>dynamically change according to the value of "x"
>
>send a carbon copy of your reply to jonx.williams_at_intel.com
>
>thanks a bunch
>
>
>Sent via Deja.com http://www.deja.com/
>Share what you know. Learn what you don't.
Received on Thu Jun 24 1999 - 11:44:41 CDT