Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: PL/Compiler
Sure you can. DBMS_SQL is there to the rescue. Note that PL/SQL is
compiled when it is submitted (that is, CREATE command triggers
compilation automagically.) And to dynamically execute this command,
you can use DBMS_SQL package. In fact, you don't even need the
CREATE - you can generate an anonymous PL/SQL block and execute
it the same way.
-- Vladimir Zakharychev (bob@dpsp-yes.com) http://www.dpsp-yes.com Dynamic PSP(tm) - the first true RAD toolkit for Oracle-based internet applications. All opinions are mine and do not necessarily go in line with those of my employer. "Itsd" <itsd2001_at_hotmail.com> wrote in message news:6e41ded2.0301201803.554a6638_at_posting.google.com...Received on Tue Jan 21 2003 - 06:16:02 CST
> Hi,
>
> I am new in PL/SQL programming.
>
> I want to know if it is possible to compile PL/SQL code at runtime?
>
> For exemple I want to dynamically create a package and then compile it.
>
> Can you tell me if it is possible to use a command that would compile the package?
> I want to use it the same way I would use the makefile command for a C program.
>
>
> Thanks