<div>
For business reasons I cann't remove the exit statement<br />
Thanks alot the second functions
</div>


For business reasons I cann't remove the exit statement
Thanks alot the second functions

<div>
<div class="content wysiwyg-content">
I have created an oracle script (execute_ky.sql) &nbsp;that can execute other scripts in the current directory as follows:<br />
@AAA.sql<br />
@BBB.sql<br />
@CCC.sql<br />
<br />
It executes just the first script and returns from sqlplus to the operative system command line.<br />
I think the behaviour is right as each internal script has the last statement<br />
&nbsp;exit;<br />
How can I avoid this behavoiu and enable it to continue executing all the scripts in the list<br />
despite the fact they have the last statement as exit.<br />
<br />
OS: Windows 7<br />
DB: Oracle 10
</div>
</div>


I have created an oracle script (execute_ky.sql)  that can execute other scripts in the current directory as follows:
@AAA.sql
@BBB.sql
@CCC.sql

It executes just the first script and returns from sqlplus to the operative system command line.
I think the behaviour is right as each internal script has the last statement
 exit;
How can I avoid this behavoiu and enable it to continue executing all the scripts in the list
despite the fact they have the last statement as exit.

OS: Windows 7
DB: Oracle 10

Execute nested scripts in sqlplus

Oracle is an object-relational database management system. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java, but it also includes support for C and C++. Oracle also has its own enterprise modules and application server software.

Oracle Database

Databases are organized collections of data, most commonly accessed through management systems including schemas, tables, queries and processes that allow users to enter and manipulate the information or utilize it in other fashions, such as with web applications or for reporting purposes.