Re: Compiling PL/SQL code without executing it
From: joel garry <joel-garry_at_home.com>
Date: Fri, 11 Jan 2013 09:08:00 -0800 (PST)
Message-ID: <91808ba4-4c8b-480c-af3a-87e3daba50ce_at_px4g2000pbc.googlegroups.com>
On Jan 10, 5:04 am, Nicolas Joyard <joyard.nico..._at_gmail.com> wrote:
> Hello,
>
> I'm looking for a way to compile PL/SQL code without actually executing it. I'm generating PL/SQL files which are then executed using SQL*Plus, but I would like to prevent executing all the files when any of them has a compilation error.
>
> I thought about creating a temporary procedure for each file and then checking its compilation status, but isn't there a more straightforward way ?
>
> Thanks,
>
> Nicolas
Date: Fri, 11 Jan 2013 09:08:00 -0800 (PST)
Message-ID: <91808ba4-4c8b-480c-af3a-87e3daba50ce_at_px4g2000pbc.googlegroups.com>
On Jan 10, 5:04 am, Nicolas Joyard <joyard.nico..._at_gmail.com> wrote:
> Hello,
>
> I'm looking for a way to compile PL/SQL code without actually executing it. I'm generating PL/SQL files which are then executed using SQL*Plus, but I would like to prevent executing all the files when any of them has a compilation error.
>
> I thought about creating a temporary procedure for each file and then checking its compilation status, but isn't there a more straightforward way ?
>
> Thanks,
>
> Nicolas
You could DBMS_UTILITY.COMPILE_SCHEMA
http://docs.oracle.com/cd/E11882_01/appdev.112/e25788/d_util.htm#i1002332
and then check all_objects for invalid ones.
Could you be a little more explicit about your requirement?
jg
-- _at_home.com is bogus. http://www.forbes.com/sites/oracle/2013/01/11/why-oracle-ceo-larry-ellison-is-so-bullish-on-sun-hardware/Received on Fri Jan 11 2013 - 18:08:00 CET