sqlDoInstall will help you to install new SQL scripts and keep track of the versions applied to your Oracle database. It allows you to rerun a failed script and restart from the point where it has failed in a previous run. It does not apply a driver+script combination that has been installed successfully. The "driver" and the supplied SQL uniquely identifies your script across the database. It'll create two tables: driverinst contains details, and driverinst_head contains a summary of the installation process. SQL installation, schema upgrades, and version tracking are easy.
Release Notes: Incorrect handling of "create type statement" has been fixed. Installation is no longer marked as FINISHED when a procedure, function, etc. was created with errors. This release will check whether the object created is valid and exit with an error if not (trigger, procedure, etc.). It stops the installation with an error if the required termination character is not found. Do not use "--" in the text of a "create comment" statement, as the rest of the line will be treated as a comment and the statement will fail.
Release Notes: A bug in the creation of objects where columns are named like '%function', '%procedure','%trigger', etc. has been fixed. The environment variable "SQL_DEBUG" can be set to either 1, 2, or 3. Level 1 will report occurrences of create function, trigger, procedure, and anonymous pl-sql blocks. Level 2 is level 1 plus generated SQL statements. Level 3 is level 2 plus every line read from the input file.