Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Strange behaviour of SQLPLUS with "create type..."

RE: Strange behaviour of SQLPLUS with "create type..."

From: <ddorr.cs_at_clearstream.com>
Date: Mon, 19 Jun 2000 15:58:26 +0200
Message-Id: <10533.109720@fatcity.com>


Enter a / at the prompt :

> SQL> create type project_t as object (pno char(5));
  2 /

Type created.

> ----------
> From: Andreas Jung[SMTP:ajung_at_sz-sb.de]
> Reply To: ORACLE-L_at_fatcity.com
> Sent: Monday, June 19, 2000 14:44
> To: Multiple recipients of list ORACLE-L
> Subject: Strange behaviour of SQLPLUS with "create type..."

>=20

> I entered the following into SQLPLUS:
>=20

> SQL> create type project_t as object (pno char(5));
>=20

> I expected that Oracle will process the statement and returns
> with the prompt. However Oracle does not return and just
> hangs waiting for any additional input.
>=20

> This looks like a bug ?! =20
>=20

> My environ: Oracle 8i, Solaris 2.7
>=20

> Andreas
>=20

> --=20
> _\\|//_
> (' O-O ')
> =
------------------------------ooO-(_)-Ooo-------------------------------=
--

> -----
> Andreas Jung, Saarbr=FCcker Zeitung Verlag und Druckerei GmbH
> Saarbr=FCcker Daten-Innovations-Center
> Untert=FCrkheimerstra=DFe 15, D-66103 Saarbr=FCcken, Germany
> Phone: +49-(0)681-502-1528, Fax: +49-(0)681-502-1509
> Email: ajung_at_sz-sb.de (PGP key available)
> =
------------------------------------------------------------------------= --
> -----
> --=20
> Author: Andreas Jung
> INET: ajung_at_sz-sb.de
>=20
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing =
Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
Received on Mon Jun 19 2000 - 08:58:26 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US