Compiling PL/SQL code without executing it
From: Nicolas Joyard <joyard.nicolas_at_gmail.com>
Date: Thu, 10 Jan 2013 05:04:22 -0800 (PST)
Message-ID: <7d4f5ccc-fe9a-4e29-95c0-85944daaf074_at_googlegroups.com>
Hello,
Date: Thu, 10 Jan 2013 05:04:22 -0800 (PST)
Message-ID: <7d4f5ccc-fe9a-4e29-95c0-85944daaf074_at_googlegroups.com>
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 Received on Thu Jan 10 2013 - 14:04:22 CET