Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: How can I run a sql script in toad or sql plus
This message was multi posted. It was answered in another newsgroup.
"Dave" <x_at_x.com> wrote in message
news:JxXyd.6408$Ar5.1631_at_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 - 12:58:36 CST