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


[code]
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

[\code]

--------------------------------------------------------------------------------

[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
 
 

--------------------------------------------------------------------------------

[amitpatel66]

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
 
 

--------------------------------------------------------------------------------

You will need to use either EXIT or QUIT at the end of each *.sql files. Else the file will not exit after executing the source code in that particular file. Try giving a "/" if you do not want to use exit or quit keyword and using a command EXIT at the END OF FILE is not said as HARD CODING.

Coming to your second requirement, I am not clear with your requirement. You do not want to hardcode the file name to which you want to SPOOL the DATA or you do not want to use SPOOL command in the sql files?

[amitpatel66]

Duplicate Threads Merged for better management of the forum

MODERATOR

[kwartz]

You will need to use either EXIT or QUIT at the end of each *.sql files. Else the file will not exit after executing the source code in that particular file. Try giving a "/" if you do not want to use exit or quit keyword and using a command EXIT at the END OF FILE is not said as HARD CODING.

Coming to your second requirement, I am not clear with your requirement. You do not want to hardcode the file name to which you want to SPOOL the DATA or you do not want to use SPOOL command in the sql files?

I want to spool the the sql file as the DOS command prompt or in the batch fill.

[amitpatel66]

This is what you are looking at:

 
CMD> SQLPLUS uid/pwd@dbname
SQL> SPOOL d:/a.txt
SQL> select * from emp;
SQL> SPOOL OFF;
SQL> EXIT;