Pls-00363

[TrynTry]

I am trying to create an object as below:
CREATE TYPE type_tst AS OBJECT(
sname VARCHAR2(9) NOT NULL DEFAULT '0',
age NUMBER NOT NULL DEFAULT 0,
idno NUMBER NOT NULL DEFAULT 0
);

I get the following error:
LINE/COL ERROR
--------
-----------------------------------------------------------------
0/0 PL/SQL: Compilation unit analysis terminated
2/1 PLS-00363: expression 'SNAME' cannot be used as an assignment
target

What am I doing wrong? If I take out NOT NULL and DEFAULT, the type is
created without any errors.


--
TrynTry
------------------------------------------------------------------------
TrynTry's Profile: http://www.highdots.com/forums/m872
View this thread: http://www.highdots.com/forums/t3002412

[DA Morgan]

TrynTry wrote: I am trying to create an object as below: CREATE TYPE type_tst AS OBJECT( sname VARCHAR2(9) NOT NULL DEFAULT '0', age NUMBER NOT NULL DEFAULT 0, idno NUMBER NOT NULL DEFAULT 0 ); I get the following error: LINE/COL ERROR -------- ----------------------------------------------------------------- 0/0 PL/SQL: Compilation unit analysis terminated 2/1 PLS-00363: expression 'SNAME' cannot be used as an assignment target What am I doing wrong? If I take out NOT NULL and DEFAULT, the type is created without any errors.

The syntax is invalid. Where did you find NOT NULL DEFAULT as valid
syntax for a user defined data type?
--
Daniel A. Morgan
http://www.psoug.org
damorgan@x.washington.edu
(replace x with u to respond)