Shell Programming and Scripting

I am trying to execute a procedure in Unix:

Here is the deal:

I have created a procedure, which works fine,it runs via a Shell script. Now I want to execute that Procedure to it can update all the rows...

Currently have the following:
shell script:

sqlplus $ES_DB_STRING @$ES_PATH/code/other/Data_patches/T5_Update_corp.sql

Exit;

My procedure creates but its still stuck on SQLPLUS...the 'exit' part does not work

secondly I want to execute this so it updates rows.:

I havce used the following:

spool $ES_LOGS/T5_T5_Update_corp.log
Whenever SQLERROR EXIT 1
Whenever OSERROR EXIT 1

SET SERVEROUTPUT ON

BEGIN

T5_Update_corp;




END;
/
--*****************
--* END OF PL/SQL *
--*****************
--------------------------------------------------------------
-- Check if Exception record was created, if so, set the
-- exit code accordingly
--------------------------------------------------------------
set feedback off


set feedback on

spool off

exit

But returns the following:
' ERROR at line 3
ora -06550 line 3, column 3
pls -00201 idendifier 'T5_Update_corp must be declared
PLSQL STATEMENT IGNORED

hence it did not work, I just want to exec the above script as in

EXEC Update Corp: (all has to be uploaded automatically)

If I understand what you want here is an example that has several lines of SQL in a shell script.

You are better off for long series of SQL commands to create
a sql script file - mycommands.sql and execute it inside sqlplus:
@mycommands

Code:

# ORACLE_HOME should be defined or sqlplus itself cannot run.

UIPW="username/password"
export UIPW

 echo $(date) " Truncating tables "
  {
    echo "set heading off"
    echo "set echo off"
    echo "truncate table rgenl;"    
    echo "truncate table bgenl;"
    echo "truncate table rfeed;"
    echo "truncate table rccnt;"
    echo "commit;"
    echo "exit;"
  } | $ORACLE_HOME/bin/sqlplus -s $UIPW