After establishing a connection with the Remote Server
(through TNVT/ Extra )I execute a shell script.
Now there are various jobs the shell performs
and depending on the exit status of the finished job,
it executes (or does not execute) the next job.
Now the problem I am facing is that whenever I initiate
an Oracle procedure to do some database updates , it takes
so much of time that my session (probably) gets timed out.
When I check the database , the job (Oracle procedure) is complete,
but as far as my shell is concerned,since it is timed out,I can't trap
the exit status of the (Oracle procedure) job.
If the job is run in background mode will the session be alive ? so that the
exit status can be trapped and further jobs carried out ?
OR alternatively can anyone suggest a way out ?
Thanks
Ajay
(through TNVT/ Extra )I execute a shell script.
Now there are various jobs the shell performs
and depending on the exit status of the finished job,
it executes (or does not execute) the next job.
Now the problem I am facing is that whenever I initiate
an Oracle procedure to do some database updates , it takes
so much of time that my session (probably) gets timed out.
When I check the database , the job (Oracle procedure) is complete,
but as far as my shell is concerned,since it is timed out,I can't trap
the exit status of the (Oracle procedure) job.
If the job is run in background mode will the session be alive ? so that the
exit status can be trapped and further jobs carried out ?
OR alternatively can anyone suggest a way out ?
Thanks
Ajay