How to run uni script with sqlplus and for loop after exitin

February 10, 2016 at 14:07:14
Specs: Windows 7
Hi ,

I have written a script in which it connects to oracle thru sqlplus session, spooling the results and exit from the sqlplus. After that i am doing a loop and this is not working as expected. But when the script alone with for loop it is working properly.

Can you tell me what is the problem here, I have existed from sqlplus by giving EXIT and EOF.Is it something i have to add that i am missing?


See More: How to run uni script with sqlplus and for loop after exitin

Report •

#1
February 11, 2016 at 09:03:12
Without seeing the script, I can only guess; Instead of using a for loop in your script, I would try a while loop.

If possible, can you post your script?


Report •
Related Solutions


Ask Question