I have written athe following program to execute a procedure number of times using korn shell scripting
Expand|Select|Wrap|Line Numbers
- for number in `cat $INPUT_FILE`
- do
- $SQLPLUS -S $sql_user_name/$sql_user_pwd@$sql_service <<EOF 1>>$LOG_FILE 2>>$LOG_FILE
- set head off;
- set echo off;
- set serveroutput on;
- exec number_names(&1);
- $number
- EOF
- done
syntax error at line 22 : `<<' unmatched
But when i executing the same program with one number(not including in the for loop) the program executed fine.
In the log file i am getting,
PL/SQL procedure successfully completed.
SP2-0042: unknown command "EOF" - rest of line ignored.
SP2-0042: unknown command "done" - rest of line ignored.
Please help me out from this issue.
Thanks in advance