Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> 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 @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 addressReceived on Thu Jun 06 2002 - 15:30:08 CDT