Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> ORACLE 9i , ERROR: PLS-00363 : expression 'SELF.ATTRIB_NUMBER' cannot be used as an assignment target

ORACLE 9i , ERROR: PLS-00363 : expression 'SELF.ATTRIB_NUMBER' cannot be used as an assignment target

From: Victor <victorveloso_at_email.com>
Date: 16 Apr 2004 15:15:47 -0700
Message-ID: <cde37e04.0404161415.1fb2db87@posting.google.com>


Trying to compile an object in Oracle 9i. Why is this throwing an exception?
Does anyone have a clue? Or all of you as puzzled as me? Any experts?

Throws error:
PLS-00363: expression 'SELF.ATTRIB_NUMBER' cannot be used as an assignment target



CREATE OR REPLACE TYPE TEST_OBJECT AS OBJECT (
  ATTRIB_NUMBER NUMBER,
  MEMBER FUNCTION TEST_FUNCTION RETURN NUMBER )
/

CREATE OR REPLACE TYPE BODY TEST_OBJECT AS   MEMBER FUNCTION TEST_FUNCTION RETURN NUMBER IS   BEGIN
     ATTRIB_NUMBER := ATTRIB_NUMBER + 1;
     RETURN ATTRIB_NUMBER;

  END;
END;
/

Any help would be greatly appreciated. Received on Fri Apr 16 2004 - 17:15:47 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US