batch file confusion: help requested !!!
529429Oct 27 2006 — edited Oct 29 2006I have created a batch file to execute sqlldr and sql file containing number of procedures in windows. For some reason I am facing two problems. I played for a while -
1. If I execute sqlloader after sql file in a batch file, SqlLoader scripts does not get executed.
The sequence has always to be, all sqlldr scripts first and then sql file scripts.
2. Also only the first sql file procedures gets executed and not the second or any other procedure after first. I changed the sql file order and tried. Same thing !!!
First gets executed and thats all.
I could apply a brute force method as workaround. Put all the procedure in one script and boom !!! I will have to succumb to the will of SQLLoader script to have priority. Though, I dont like this kind of behaviour.
I am not using exit commands, anywhere, anytime.
But I request to know the reason behind it. Its very much possible (infact true !!!) that I am doing something wrong. Please guide folks !!!.
Thanks
Som