Re: SQL*Plus doesn't execute the CREATE TYPE query

In article <3c7fc954$1_at_news.uni-rostock.de>, "Lars says...
>
>To explain my problem I use a simple query:
>CREATE TYPE test_type AS OBJECT ( id integer );
>After typing in this query at the SQL*Plus (V9.0.1.0.0) command line nothing
>happens - there
>is still the prompt for entering more commands.
>I think after entering a simicolon and pressing enter the query should be
>executed and at least
>produce an error.
>
>Okay, here is how it reads in SQL*Plus:
>SQL> CREATE TYPE test_type AS OBJECT ( id integer );
> 2
>
>
>Why is this query not executed?
>Thanks for your help.
>
>

use

/   

on a line by itself to run the block of code you put in to the buffer.

--
Thomas Kyte (tkyte@us.oracle.com)             http://asktom.oracle.com/ 
Expert one on one Oracle, programming techniques and solutions for Oracle.
http://www.amazon.com/exec/obidos/ASIN/1861004826/  
Opinions are mine and do not necessarily reflect those of Oracle Corp