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

Home -> Community -> Usenet -> c.d.o.server -> Sqlplus: Blank lines in @-included script?

Sqlplus: Blank lines in @-included script?

From: Ole Christian Meldahl <konocm_at_statoil.com>
Date: Mon, 06 Sep 1999 10:36:09 +0200
Message-ID: <37D37CF9.79E640FF@statoil.com>


Hi

How can I avoid Sqlplus from assuming that the command is finished when I include a file with @ or @@?

file test:sql contains
select sysdate

from dual
/

--- EOF--- Then in Sqlplus:

SQL> @test
SQL> select sysdate
  2
SQL> from dual
unknown command "from dual" - rest of line ignored. SQL> Input truncated to 1 characters
/

select sysdate

             *
ERROR at line 1:
ORA-00923: FROM-nøkkelord ble ikke funnet i forventet posisjon

ole c Received on Mon Sep 06 1999 - 03:36:09 CDT

Original text of this message

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