| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Strange behaviour of SQLPLUS with "create type..."
I believe you must terminate the definition of an object
using a forward slash. For example:
CREATE TYPE project_t as object (
pno CHAR(5)
);
/
Since a type can contain PL/SQL procedure definitions as well as variable definitions, a semicolon isn't enough to tell SQL*Plus that you are done.
Jonathan
On Mon, 19 Jun 2000 04:44:15 -0800, you wrote:
>I entered the following into SQLPLUS:
>
>SQL> create type project_t as object (pno char(5));
>
>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.
>
>This looks like a bug ?! =20
>
>My environ: Oracle 8i, Solaris 2.7
>
>Andreas
>
>--=20
> _\\|//_
> (' O-O ')
>------------------------------ooO-(_)-Ooo-------------------------------=
 |
 |