Re: PL/Compiler

What exactly are you trying to do? If you exectute the "CREATE PACKAGE" statement, the code is compiled as you add it to the database. If you want to use a PL/SQL script to create package code and then add it to the database, you will have to use the "SPOOL" statement to generate a script on-the-fly to add the packagae. And since the dynamically created script is what really matters, it can be generated by anything (KornShell, Perl, C++, etc). Once your script has generated another script containing the "CREATE PACKAGE" statement, all you have to do is execute it just like any other SQL script.

HTH, Kaptain524

itsd2001_at_hotmail.com (Itsd) wrote in message news:<6e41ded2.0301201803.554a6638_at_posting.google.com>...
> 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
Received on Tue Jan 21 2003 - 13:13:45 CST