Re: How can I run a sql script in toad or sql plus

From: Dave <x_at_x.com>
Date: Fri, 24 Dec 2004 16:33:45 GMT
Message-ID: <JxXyd.6408$Ar5.1631@text.news.blueyonder.co.uk>

"ing_ora" <zana_f_at_hotmail.com> wrote in message news:1103900237.743572.229610_at_f14g2000cwb.googlegroups.com...
> Hello all,
>
> I have a sql file ( worksshop_plsql.sql) wich contains those files:
> ------ the content of the file------------
> SPOOL workshop_plsql.lst
>
> @@ workshop_plsql.drp
> @@ workshop_plsql.tab
> @@ workshop_plsql.con
> @@ workshop_plsql.sqs
> @@ workshop_plsql.trg
> @@ workshop_plsql.dat
>
> SPOOL OFF
> -------------------------------------------
> when I load this file into the sql window of toad and tried to run it
> as script. i get as script output this below:
>
> SPOOL workshop_plsql.lst
> ^----------------
> Statement Ignored
> ^----------------
> Statement Ignored
> ^----------------
> Statement Ignored
> ^----------------
> Statement Ignored
> ^----------------
> Statement Ignored
> ^----------------
> Statement Ignored
> SPOOL OFF
>
> So can you tell me how you can run such file correctly. I appreciate
> your help .Thank you
>

run it in sqlplus Received on Fri Dec 24 2004 - 10:33:45 CST