Quick Search:
CODE
Oracle PL/SQL Code Library
JOBS
Find Or Post Oracle Jobs
FORUM
Oracle Discussion & Chat
 The Oracle PL/SQL OPAQUE Keyword      [Return To Index] Jump to:  
  Looking for the original pages? (formerly called "Morgan's Library") You can find them here.

Term: OPAQUE

Definition:
In Oracle PL/SQL, OPAQUE refers to the abstract data types whose internal representation are maintained by Oracle. The opaque type available in Oracle is XMLType. The XMLType data is stored as series of bytes and Oracle does not expose this internal representation. There are separate methods provided by Oracle to access the OPAQUE data.

Example Usage:

A table named XMLTEST of XMLType is created. A XML document is inserted as a whole (as a CLOB), whose internal representation is not known.

SQL> CREATE TABLE XMLTEST OF XMLTYPE;

Table created.

SQL> INSERT INTO XMLTEST values
(XMLType(bfilename('XMLDIR','X.xml'),
nls_charset_id('AL32UTF8')))

1 row inserted.

SQL>SELECT value(s)
FROM xmltest i,
TABLE(XMLSequence(
EXTRACT(i.object_value, '/Business/Location/Service/Basics/Attribute[Name="id"]'))) s



Related Links:
 
Home      :      Code Library      :      Sponsors      :      Privacy      :      Terms of Use      :      Contact Us 205 users online    © 2009 psoug.org
PSOUG LOGIN
Username: 
Password: 
Forgot your password?