Urgent Help Needed

[kwartz]

Can somebody please help me resolve this?

I have a batch file that copies various sql file into a temp folder. Then run the sql file from the temp location. However, I have to type exit at the sql prompt when on file is done for it move to the next file. I don't what to hard code exit in the sql script, how do I go about this? Also I want to spool each sql file but don't want to hard code it as well.
Please help as I dire need and my project is behind schedule.

Thanks

copy c:\text1.sql  c:\temp
copy c:\text2.sql  c\temp
copy c:\text3.sql  c:\tem
 
sqlplusw user/admin@mtestdb  @c:\temp\text1.sql
sqlplusw user/admin@mtestdb  @c:\temp\text2.sql
sqlplusw user/admin@mtestdb  @c:\temp\text3.sql
 

[eWish]

Why did you post this question twice in the Oracle Forum and in here as well? Please do not double and triple post your question.

--Keivn

[kwartz]

Double posting in the oracle forum was a mistake, I tried deleting one copy but it didn't work. I didn't know under which category to post hence my posting here as well since what I really want is more to do with batch scripting than oracle I thought somebody here can help. Anyway, I will try to help make managing the various forums more efficient by not double or triple posting.

Thank you