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)