Code Listing 5: Creating a document type object and member functions

create or replace type hlq_dockey_ty as object
(xdb_uri     sys.xdburitype
,xdb_rowid   varchar2(18)
,xml_ref     ref sys.xmltype
--
,member function get_xdb_uri   return sys.xdburitype
,member function get_xdb_path  return varchar2
,member function get_xdb_rowid return varchar2
,member function get_xml_ref   return ref sys.xmltype
,member function get_xml       return sys.xmltype
,member function get_clob      return clob
);
/
show errors
create or replace type body hlq_dockey_ty as
  member function get_xdb_path
  return varchar2
  is
  begin
    return xdb_uri.geturl();
  end;

  member function get_xml
  return sys.xmltype
  is
  begin
    return xdb_uri.getxml();
  end;

  member function get_clob
  return clob
  is
  begin
    return xdb_uri.getclob();
  end;
  
  -- ... more...
end;
/
show errors

E-mail this page
Printer View Printer View
Oracle Is The Information Company About Oracle | Oracle RSS Feeds | Careers | Contact Us | Site Maps | Legal Notices | Terms of Use | Privacy