Re: ??? SQL> with Script doesn't work ???
From: Steve Rainbird <steve.rainbird_at_nospam.mssint.com>
Date: Fri, 7 Jun 2002 09:11:16 +0000 (UTC)
Message-ID: <adptbk$abl$1_at_paris.btinternet.com>
Date: Fri, 7 Jun 2002 09:11:16 +0000 (UTC)
Message-ID: <adptbk$abl$1_at_paris.btinternet.com>
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...Received on Fri Jun 07 2002 - 11:11:16 CEST
> 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