I want to execute a sql script with SqlPlus in a shell script. Something like this:
sqlplus usr/pwd@SID @../../procedures/insert_test.sql
This works and creates the procedure but ends with sqlplus still running:
Oracle Database 11g Enterprise Edition Release 220.127.116.11.0 - 64bit Production
With the Partitioning option
How should this be done so that sqlplus closes after the procedure is created?