??? SQL> with Script doesn't work ???
Date: Thu, 06 Jun 2002 20:55:53 +0200
Message-ID: <3CFFB039.ABB0395D_at_gmx.de>
Hi all,
the following script (even if it was taken from a website) doesn't work,
when I call it with _at_script.sql in SQLPLUS:
/* Object Types in Relational Tables */
CREATE OR REPLACE TYPE address_type
CREATE OR REPLACE TYPE cust
CREATE TABLE customer OF cust(id PRIMARY KEY);
There is no error message, but the script causes a number appearing on
the screen (the number of lines in the script) and the SQL> prompt
doesn't come up again. I have to type . to go back to SQL> prompt and
nothing has happened. What could that be?
AS OBJECT (
line1 VARCHAR2(80),
post_code VARCHAR2(10),
country VARCHAR2(50)
);
AS OBJECT (
Id NUMBER(12),
Name VARCHAR2(75),
Address address_type
);
Thanks,
Christian
Received on Thu Jun 06 2002 - 20:55:53 CEST