Re: SQL*Plus Problem--Pls help !!

agichen wrote:
>
>
> Hello,
> I have some weekly and monthly routine jobs.
> 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 *
> The fastest and easiest way to search and participate in Usenet - Free!
>
Create a test schema and run the script first in SQL Plus before submitting it to the cron job. BTW you can also schedule jobs within Oracle itself which may make more sense if they are just SQL scripts.

HTH RC

--
Posted via CNET Help.com
http://www.help.com/