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?
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?