Re: SQL*PLus script for running external scripts

From: gazzag <gareth_at_jamms.org>
Date: Mon, 9 Feb 2009 07:44:00 -0800 (PST)
Message-ID: <7a90abc8-0533-4674-9dd3-eacdf8d3205f_at_p37g2000yqd.googlegroups.com>

On 9 Feb, 15:34, "Álvaro G. Vicario"
<alvaro.NOSPAMTH..._at_demogracia.com> wrote:
> ddf escribió:
>
>
>
>
>
> > The _at_@ syntax says 'run this script from the same location as the
> > source script', so if you do, indeed, locate all of these in one
> > directory the _at_@ syntax will be what you need.  As an example:
>
> > The directory contents --
>
> > c:\sql\orcl\examples\tst>dir
> >  Volume in drive C has no label.
> >  Volume Serial Number is A08D-1EEA
>
> >  Directory of c:\sql\orcl\examples\tst
>
> > 02/09/2009  07:55 AM    <DIR>          .
> > 02/09/2009  07:55 AM    <DIR>          ..
> > 02/09/2009  07:55 AM                76 master.sql
> > 02/09/2009  07:51 AM               138 script01.sql
> > 02/09/2009  07:54 AM               239 script02.sql
> >                3 File(s)            453 bytes
> >                2 Dir(s)  21,441,359,872 bytes free
>
> > c:\sql\orcl\examples\tst>
>
> > The master.sql script --
>
> > set echo on
> > spool master.log
> > _at__at_script01.sql
> > _at__at_script02.sql
> > spool off
>
> > Executing master.sql --
>
> > SQL> _at__at_script01.sql
> > SQL> create table yakima(
> >   2          snerg   number,
> >   3          florpal varchar2(40)
> >   4  );
>
> > Table created.
>
> > SQL>
> > SQL>
> > SQL> alter table yakima
> >   2  add constraint yakima_pk
> >   3  primary key(snerg);
>
> > Table altered.
>
> > SQL>
> > SQL> _at__at_script02.sql
> > SQL> create table terpal(
> >   2          sming varchar2(80),
> >   3          yertz   number,
> >   4          oplama  number
> >   5  );
>
> > Table created.
>
> > SQL>
> > SQL> alter table terpal
> >   2  add constraint terpal_pk
> >   3  primary key(sming);
>
> > Table altered.
>
> > SQL>
> > SQL> alter table terpal
> >   2  add constraint terpal_fk
> >   3  foreign key(yertz)
> >   4  references yakima;
>
> > Table altered.
>
> > SQL>
>
> I've copied your example line by line (it works fine) and started
> modifying it. The issue happened to be blank lines. It's okay if I have:
>
> create table yakima(
>         snerg   number,
>         florpal varchar2(40)
> );
>
> But it won't work with:
>
> create table yakima(
>         snerg   number,
>
>         florpal varchar2(40)
> );
>
> SQL> create table yakima(
>    2          snerg   number,
>    3
> SQL>         florpal varchar2(40)
> SP2-0734: inicio "florpal va..." de comando desconocido - resto de la
> lÝnea ignorado.
> SQL> );
> SP2-0042: comando desconocido ")" - resto de la lÝnea ignorado.
>
> Can't you have blank lines in script files?
>
> --
> --http://alvaro.es- Álvaro G. Vicario - Burgos, Spain
> -- Mi sitio sobre programación web:http://bits.demogracia.com
> -- Mi web de humor al baño María:http://www.demogracia.com

SQL*Plus isn't great on blank lines, to be honest. I tend to use "--" (comment) if I want to space out a script.

HTH -g Received on Mon Feb 09 2009 - 09:44:00 CST