SQL*Plus Problem--Pls help !!

[Quoted]     I have some weekly and monthly routine jobs. [Quoted]     Usually,I schedule my job via crontab launching sql*plus.     My scripts have lots of DML(DDL) statements,now the problem is     how should I know that my script is correct without any syntax error or mistyping(ex. just loss a semicolon) ??

    I always find some errors after executing the script,is there any method can be used to detect any errors before running the script ??

    Thanks for any suggestions !!
    Any idea ?

Rgds,
Agi

• Sent from RemarQ http://www.remarq.com The Internet's Discussion Network * [Quoted] The fastest and easiest way to search and participate in Usenet - Free!