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

ing_ora wrote:
> 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
>

Try @@workshop_plsql.dat (note there's NO space between the @@ and the filename. The @@ has no use here, you can use @ (a single at sign)

-- 
Regards,
Frank van Bortel