Oracle Community Directory
Oracle Community FAQ
My Oracle Support Community (MOSC)
Go Directly To
Oracle Technology Network Community
My Oracle Support Community
OPN Cloud Connection
Oracle Employee Community
Oracle User Group Community
OTN Speaker Bureau
Oracle Database 11g Express Edition Beta
Please enter a title.
You can not post a blank message. Please type your message and try again.
This discussion is archived
: Aug 26, 2011 10:51 AM by
CREATE TYPE does not seem to...
Aug 26, 2011 10:27 AM
Can XE use CREATE TYPE?
When I enter the following statement, sqlplus returns with the line continuation prompt and appears to expect something more. Should this work?
CREATE TYPE mytype AS OBJECT (thenum NUMBER(10), thestreet CHAR(40));
This content has been marked as final.
Show 1 reply
Re: CREATE TYPE does not seem to...
Aug 26, 2011 10:51 AM
in response to
Perhaps it's a bug in sqlplus. I get the same result when running the posted command. However, the following variation works for me...
CREATE TYPE mytype AS OBJECT (thenum NUMBER(10), thestreet CHAR(40)) /
Also, sqldeveloper has no trouble with the semicolon.