Dynamically creating procedures

From: <vjavaly_at_hotmail.com>
Date: Fri, 12 Mar 1999 17:10:44 GMT
Message-ID: <7cbhqb$l11$1@nnrp1.dejanews.com>

I'm looking for ideas as to how to do the following: From an Oracle8.03 PL/SQL procedure, create a new procedure and compile it into the database.

Here's what I've done so far: Created a GENERATOR procedure to generate new procedures based on parameters. This GENERATOR procedure calls an external procedure (actually it calls the wrapper procedure which calls a C program) which create a file which contains the source code for the new procedure.

At this point, I could have the C program invoke SQL*Plus (through the SYSTEM command) and START the new procedure source file to compile it. However, I would like to find another way to compile the new procedure.

Any ideas would be appreciated. Please reply to vjavaly_at_hotmail.com. Thank you in advance.

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Fri Mar 12 1999 - 11:10:44 CST