Hiya. I am running a script saved as L:\MY_SCRIPT.SQL from command line.
I want the script to execute, then close SQLPLUS.
I am trying all the suggested code , adding EXIT. QUIT, . (period) to MY_SCRIPT.SQL and get errors.
Without these statements the script runs successfully but SQLPLUS stays open.
Oracle 12C 18.104.22.168
Below is the command I cam using
C:\ sqlplus MY_SCHEMA/my_password@MY_DATABASE_LINK @L:\MY_SCRIPT.SQL
The script I am running is straight from Oracle documents:
x NUMBER := 100;
FOR i IN 1..10 LOOP
IF MOD (i, 2) = 0 THEN --i is even
INSERT INTO temp VALUES (i, x, 'i is even');
INSERT INTO temp VALUES (i, x, 'i is odd');
x := x + 100;
Below is the output including error:
SQL*Plus: Release 22.214.171.124.0 Production on Sat Apr 1 15:54:59 2017
Copyright (c) 1982, 2014, Oracle. All rights reserved.
Last Successful login time: Sat Apr 01 2017 15:50:29 -04:00
Oracle Database 12c Enterprise Edition Release 126.96.36.199.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing opt
ERROR at line 14:
ORA-06550: line 14, column 4:
PLS-00103: Encountered the symbol "." The symbol "." was ignored.