Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: How can I run a sql script in toad or sql plus

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

From: Randy Harris <randy_at_SpamFree.com>
Date: Fri, 24 Dec 2004 18:58:36 GMT
Message-ID: <wFZyd.5597$by5.1619@newssvr19.news.prodigy.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US