PL/SQL (MOSC)

MOSC Banner

Do oracle objects have two types of NULL?

edited Jan 25, 2012 12:58AM in PL/SQL (MOSC) 7 comments
 I' m looking for an explanation for that case:
I create an object type an its related collection type.
If I create a NULL row with a constructor I can't compare it with a NULL row create with extend method.
Have a look at the example code:

DROP TYPE ORATEST_TYPE_EMAIL_TABLE;

DROP TYPE ORATEST_TYPE_EMAIL;

CREATE OR REPLACE TYPE "ORATEST_TYPE_EMAIL" AS OBJECT
(
   OI_LINE_ID NUMBER (15),
   OI_OFF_ID NUMBER (20),
   OI_CHANGING_DATE DATE,
   OI_EMAIL_STRING VARCHAR2 (254),
   MAP MEMBER FUNCTION MAPPER
      RETURN VARCHAR2,
     CONSTRUCTOR FUNCTION ORATEST_TYPE_EMAIL
      RETURN SELF AS RESULT   
);
/

CREATE OR REPLACE TYPE BODY ORATEST_TYPE_EMAIL

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center