Shell Programming and Scripting

$ORACLE_HOME/bin/sqlplus $ORA_DBCU/$ORA_DBCP <<EOD

$ORACLE_HOME/bin/sqlplus $ORA_DBCU/$ORA_DBCP <<EOD

$ORACLE_HOME/bin/sqlplus $ORA_DBCU/$ORA_DBCP <<-EOD

... put the shebang; assign the variables
sqlplus $ORA_DBCU/$ORA_DBCP <<EOD
select sysdate from dual;
EOD

cat <file> | tr -d '\r'

cat foo.sql | mysql
mysql < foo.sql
mysql <<EOD
use foo;show tables;
EOD

$ 
$ # In Bash
$ printf "set serveroutput on\n exec sp_test(p_yr_qtr => 4)" | sqlplus -s test/test
From procedure sp_test: input p_yr_qtr = 4

PL/SQL procedure successfully completed.

$ 
$

$ 
$ # display the content of the shell script
$ cat -n call_ora_proc.sh
     1    #!/usr/bin/bash
     2    export ORA_DBCU=test
     3    export ORA_DBCP=test
     4    export YR_QTR=4
     5    export spool_file=call_ora_proc.log
     6    printf "clear columns breaks computes
     7    set recsep off wrap off heading off pagesize 0 space 0 newpage 0 serveroutput on
     8    spool ${spool_file}
     9    exec sp_test(${YR_QTR});
    10    spool off
    11    exit" | $ORACLE_HOME/bin/sqlplus -s $ORA_DBCU/$ORA_DBCP 1>/dev/null
$ 
$ # run the shell script
$ . call_ora_proc.sh
$ 
$ # and check the log file created by it
$ cat call_ora_proc.log
From procedure sp_test: input p_yr_qtr = 4                                      

PL/SQL procedure successfully completed.

$ 
$