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)