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>


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

Original text of this message