??? SQL> with Script doesn't work ???

From: Christian Graf <chrille.graf_at_gmx.de>
Date: Thu, 06 Jun 2002 20:55:53 +0200
Message-ID: <3CFFB039.ABB0395D@gmx.de>

Hi all,

the following script (even if it was taken from a website) doesn't work, when I call it with @script.sql in SQLPLUS:

/* Object Types in Relational Tables */

CREATE OR REPLACE TYPE address_type

        AS OBJECT (
                line1 VARCHAR2(80),
                post_code VARCHAR2(10),
                country VARCHAR2(50)   

);
  

CREATE OR REPLACE TYPE cust

        AS OBJECT (
                Id NUMBER(12),
                Name VARCHAR2(75),
                Address address_type

);
  

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?

Thanks,
Christian Received on Thu Jun 06 2002 - 13:55:53 CDT