Re: Designing a PL/SQL app.

From: Chris Weiss <weisschr_at_pilot.msu.edu>
Date: Tue, 25 May 1999 11:46:51 -0400
Message-ID: <7ieglo$j9v$1@msunews.cl.msu.edu>

Rather than building a procedure, you can build anonymous blocks for dynamic PL/SQL. You can pass the anonymous block as a string and use it repeatedly. You can also split the block in two, redefining the DECLARE section to change the values used. This will avoid the drop and build part of using a procedure.

Christopher Weiss
Professional Services Division
Compuware Corporation

Thomas Bierhance <Bierhance_at_orbital-computer.de> wrote in message news:3749C64B.46E20D4C_at_orbital-computer.de...
> > I could write a procedure which in turn would build another
> > procedure, piecing together the function calls, conditions, etc. that I
need
> > from the external file, and integrate it into the rest of the source
code I
> > need for each iteration.
> >
>
> Yup, that's exactly what I think to be a good solution for your problem,
though
> every compilation will take some time...
>
Received on Tue May 25 1999 - 10:46:51 CDT