Re: Pls-00363

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_at_x.washington.edu
(replace x with u to respond)