How can I run a sql script in toad or sql plus
This is a discussion on How can I run a sql script in toad or sql plus within the Oracle Miscellaneous forums, part of the Oracle Database category; --> Hello all, I have a sql file ( worksshop_plsql.sql) wich contains those files: ------ the content of the file------------ ...
| |||||||
| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
04-08-2008, 05:28 AM
| ||||
| ||||
 How can I run a sql script in toad or sql plus 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      |
|
04-08-2008, 05:28 AM
| |||
| |||
| Re: How can I run a sql script in toad or sql plus "ing_ora" <zana_f@hotmail.com> wrote in message news:1103900237.743572.229610@f14g2000cwb.googlegr oups.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 |
|
04-08-2008, 05:28 AM
| ||||
| ||||
| 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@x.com> wrote in message news:JxXyd.6408$Ar5.1631@text.news.blueyonder.co.u k... > > "ing_ora" <zana_f@hotmail.com> wrote in message > news:1103900237.743572.229610@f14g2000cwb.googlegr oups.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 > > |
Linear Mode
