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

Put a / (slash) at the end.

--
Steve Rainbird
Principal consultant
MSS International Ltd.
www.mssint.com

Remove "nospam" from email address to reply
"Christian Graf" <chrille.graf_at_gmx.de> wrote in message
news: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 @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