Script not waiting for command to complete

[wpepper]

We have a batch file which runs a script and then creates a file which we use as flag for the next batch file.

Occasionally, the flag file is created before the script is complete causing the next step in the process to fail because it requires a table from the first step. Has anyone run across this problem and found a workaround?

Thanks,

Script
sqlplus -S ID/Password@vod @\\vodcaicluster\Oracle\DataMarts\CT\Scripts\in_rpt_CTBHK_Daily_Auth.txt > \\vodcaicluster\Oracle\DataMarts\CT\Output_Files\out_rpt_CTBHK_Daily_Auth.txt
dir> \\vodcaicluster\Oracle\events\censusflag.txt

[gandolf989]

Have the sql script create the file using the "!" host command.