Difference between revisions of "OE.CATALOG TYP (type)"

From dbscript Online Help
Jump to: navigation, search
 
Line 2: Line 2:
  
 
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
|-
+
|- valign="top"
 
| '''Type
 
| '''Type
 
| OE.CATALOG_TYP
 
| OE.CATALOG_TYP
|-
 
 
|}
 
|}
 
  
 
=== Source ===
 
=== Source ===

Latest revision as of 07:15, 24 June 2010

wikibot[edit]

Type OE.CATALOG_TYP

Source[edit]

CREATE OR REPLACE TYPE catalog_typ
                                         UNDER composite_category_typ
      (
    MEMBER FUNCTION getCatalogName RETURN VARCHAR2
       , OVERRIDING MEMBER FUNCTION category_describe RETURN VARCHAR2
      );TYPE BODY catalog_typ AS
  OVERRIDING MEMBER FUNCTION category_describe RETURN varchar2 IS
  BEGIN
    RETURN 'catalog_typ';
  END;
  MEMBER FUNCTION getCatalogName RETURN varchar2 IS
  BEGIN
    -- Return the category name from the supertype
    RETURN self.category_name;
  END;
END;