unix - How to avoid series of commands running under sql plus using shell script

Question

I have created a script which runs a series of other instances in shell using the while command. But the problem is that one of the job is connecting to sql plus and running the remaining command under sqlplus.

For ex. my input file --> job.txt

job1
job2
job3

Now, using the below script I am calling job one by one. So, until the present job is finished next job wont start. But the catch comes when the job tries to connect the sql plus. After it connects to sql plus, the process id of the current job gets complete and remaining jobs run as the sql statement in unix env.

while read line;
do 
    $job1 
done < job.txt;

Error message I am getting in sqlplus after current instance exits.

SP2-0042: unknown command

How can I avoid bringing the jobs under sqlplus.

question from:https://stackoverflow.com/questions/66045922/how-to-avoid-series-of-commands-running-under-sql-plus-using-shell-script

Answer 1

Waitting for answers