Oracle Types and Constructor Problem

From: <nicholas.wakefield_at_gmail.com>
Date: 8 Jul 2005 13:47:53 -0700
Message-ID: <1120855673.118643.191110@f14g2000cwb.googlegroups.com>

Hi,

Anyone know why I'm having trouble making this constructor working. It's throwing

SELECT NEW customer_info_t(1, 'a','b',sysdate,2323) from dual;

Error on line 0
SELECT NEW customer_info_t(1, 'a','b',sysdate,2323) from dual

ORA-06552: PL/SQL: Statement ignored
ORA-06553: PLS-302: component 'CUSTOMER_INFO_T' must be declared

--CUSTOMER_INFO_T CREATE OR REPLACE TYPE customer_info_t AS OBJECT (   CUST_ID INTEGER ,
  FRST_NM VARCHAR2(256 BYTE),
  LST_NM VARCHAR2(156 BYTE),

  DOB      DATE,
  SSN      NUMBER,

 CONSTRUCTOR FUNCTION customer_info_t(CUST_ID INTEGER,

                                      FRST_NM  VARCHAR2,
                                      LST_NM   VARCHAR2,
                                      DOB      DATE,
                                      SSN      NUMBER) RETURN
                                      SELF AS RESULT

  ) ;
/

--CUSTOMER_INFO_T CREATE OR REPLACE TYPE customer_info_t AS OBJECT (   CUST_ID INTEGER ,
  FRST_NM VARCHAR2(256 BYTE),
  LST_NM VARCHAR2(156 BYTE),

  DOB      DATE,
  SSN      NUMBER,

  CONSTRUCTOR FUNCTION customer_info_t(CUST_ID INTEGER,

                                       FRST_NM  VARCHAR2,
                                       LST_NM   VARCHAR2,
                                       DOB      DATE,
                                       SSN      NUMBER) RETURN
                                       SELF AS RESULT	IS
  BEGIN
        SELF.FRST_NM := FRST_NM;
		SELF.LST_NM := LST_NM;
		SELF.SSN := SSN;
		SELF.CUST_ID := CUST_ID;
        SELF.DOB := DOB;
    	RETURN;
  END;
END;	         

/
Received on Fri Jul 08 2005 - 15:47:53 CDT