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

"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 _at_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

Stop crossposting, especially to groups (comp.databases.oracle) that are not being transmitted by every provider
and add an extra / on the line after the ; in the CREATE TYPE definitons.

Regards

--
Sybrand Bakker
Senior Oracle DBA

to reply remove '-verwijderdit' from my e-mail address