Pls-00363

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

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