SQL/Plus: script-problems
From: Thomas Gsuck <gsuck_at_rvs.uni-hannover.de>
Date: Fri, 1 Jul 1994 11:19:03 GMT
Message-ID: <1994Jul1.111903.28744_at_newsserver.rrzn.uni-hannover.de>
Date: Fri, 1 Jul 1994 11:19:03 GMT
Message-ID: <1994Jul1.111903.28744_at_newsserver.rrzn.uni-hannover.de>
Hi !
I have a problem concerning a small sql-script.
When typing this "thing" directly into sql/plus,
everything works fine.
But when trying to load with 'get "......."' and then run with 'r'
I always get a 'missing right parenthesis'. Can YOU help me ?
(this has to be a real stupid one, but i can`t see nooothing...)
Thanks for any help in advance (email preferred)
Here is the script: (sorry, german comments...)
/* nup.sql * * Anlegen der Tabelle NUP im Kataster * (als User KAT !) * * 1.7.94 Thomas Gsuck * */ CREATE TABLE kat.nup (id number(4), kabel number(5) CONSTRAINT nn_kabel NOT NULL, name VARCHAR2(80), suchtiefeL number(2), vFilterL VARCHAR2(80), eFilterL VARCHAR2(80), suchtiefeR number(2), vFilterR VARCHAR2(80), eFilterR VARCHAR2(80), bem1 VARCHAR2(255), bem2 VARCHAR2(255), bem3 VARCHAR2(255), CONSTRAINT const_nup PRIMARY KEY (id)
***>>>! FOREIGN KEY (kabel) REFERENCES kat.kabel(nummer) ON DELETE CASCADE );
CREATE UNIQUE INDEX nup1 ON kat.nup (id); /**/
------------END
The problematic line is signed by ***>>>!
Received on Fri Jul 01 1994 - 13:19:03 CEST