Re: Designing a PL/SQL app.

I'm thinking about the problem some more, and I think I have an idea that could work. 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.

I guess I would need to use DBMS_SQL to "create-or-replace" the procedure I build.

I could then iteratively call the procedure I just created.

Then I could drop the procedure at end-of-job.

Sound like a plan?

Thomas Bierhance wrote:

> As you are about to use 100 or more functions your code would have to take
> hundreds of if-statements to achieve what you are looking for. The most
> difficult part would be the evalution of expression like "somevalue < 2",
> you could use dynamic sql for that.
> I think writing a small "compiler" for your source code - you could use
> PL/SQL for that - would be a much better solution, but that depends on the
> frequency of updates that are applied to your external file.
Received on Sun May 23 1999 - 20:08:46 CDT