Oracle DBMS_XQUERYINT
Version 19.2.0.1

General Information
Library Note Morgan's Library Page Header
For how many years have you been working with physical servers that are starving your database of the memory necessary to deploy important new performance features such as the Result Cache, Memoptimize Pool, In-Memory Aggregation, In-Memory Column Store, and Full Database Caching? Too long? Contact me to learn how to improve all queries ... not just some queries.
Purpose Internal support for database XQuery
AUTHID CURRENT_USER
Constants
Name Data Type Value
 Fragment Flags
QMXQRS_JAVA_FRAGMENT NUMBER 1
QMXQRS_JAVA_SCHEMABASED NUMBER 2
 Variable Bind Is A SQL Scalar Input Value
QMXQRS_JAVA_XS_DEC_INPUT NUMBER 4
QMXQRS_JAVA_XS_STR_INPUT NUMBER 8
QMXQRS_JAVA_XS_FLT_INPUT NUMBER 16
QMXQRS_JAVA_XS_DBL_INPUT NUMBER 32
QMXQRS_JAVA_XS_DATE_INPUT NUMBER 64
QMXQRS_JAVA_XS_TIME_INPUT NUMBER 128
QMXQRS_JAVA_XS_DATETIME_INPUT NUMBER 256
QMXQRS_JAVA_XDT_DYTMDUR_INPUT NUMBER 512
QMXQRS_JAVA_XDT_YRMONDUR_INPUT NUMBER 1024
 Called by EXISTS Evaluation
QMXQRS_JAVA_CHK_EXSTS NUMBER 2048
QMXQRS_JAVA_NO_DOCWRAP NUMBER 4096
 qmt.h Constants
QMTXT_ANYTYPE NUMBER 0
QMTXT_ANYSIMPLETYPE NUMBER 1
QMTXT_STRING NUMBER 2
QMTXT_BOOLEAN NUMBER 3
QMTXT_DECIMAL NUMBER 4
QMTXT_FLOAT NUMBER 5
QMTXT_DOUBLE NUMBER 6
QMTXT_DURATION NUMBER 7
QMTXT_DATETIME NUMBER 8
QMTXT_TIME NUMBER 9
QMTXT_DATE NUMBER 10
QMTXT_GDAY NUMBER 11
QMTXT_GMONTH NUMBER 12
QMTXT_GYEAR NUMBER 13
QMTXT_GYEARMONTH NUMBER 14
QMTXT_GMONTHDAY NUMBER 15
QMTXT_HEXBINARY NUMBER 16
QMTXT_BASE64BINARY NUMBER 17
QMTXT_ANYURI NUMBER 18
QMTXT_QNAME NUMBER 19
QMTXT_NOTATION NUMBER 20
 Derived Constants
QMTXT_NORMALIZEDSTRING NUMBER 21
QMTXT_TOKEN NUMBER 22
QMTXT_LANGUAGE NUMBER 23
QMTXT_NMTOKEN NUMBER 24
QMTXT_NMTOKENS NUMBER 25
QMTXT_NAME NUMBER 26
QMTXT_NCNAME NUMBER 27
QMTXT_ID NUMBER 28
QMTXT_IDREF NUMBER 29
QMTXT_IDREFS NUMBER 30
QMTXT_ENTITY NUMBER 31
QMTXT_ENTITIES NUMBER 32
QMTXT_INTEGER NUMBER 33
QMTXT_NONPOSITIVEINTEGER NUMBER 34
QMTXT_NEGATIVEINTEGER NUMBER 35
QMTXT_LONG NUMBER 36
QMTXT_INT NUMBER 37
QMTXT_SHORT NUMBER 38
QMTXT_BYTE NUMBER 39
QMTXT_NONNEGATIVEINTEGER NUMBER 40
QMTXT_UNSIGNEDLONG NUMBER 41
QMTXT_UNSIGNEDINT NUMBER 42
QMTXT_UNSIGNEDSHORT NUMBER 43
QMTXT_UNSIGNEDBYTE NUMBER 44
QMTXT_POSITIVEINTEGER NUMBER 45
 XDB Standard Simple Types & Oracle Extensions
QMTXT_REF NUMBER 46
QMTXT_QNAMES NUMBER 47
 XDT Basic Types: Type Beginning
  NUMBER 48
  NUMBER 49
  NUMBER 50
  NUMBER 51
  NUMBER 52
 XDT Basic Types: Type Ending
QMTXT_INVALIDTYPE NUMBER 255
???
DTYCHR NUMBER 1
DTYNUM NUMBER 2
DTYBIN NUMBER 23
DTYIBFLOAT NUMBER 100
DTYIBDOUBLE NUMBER 101
DTYSTZ NUMBER 181
DTYIYM NUMBER 182
DTYIDS NUMBER 183
DTYESTZ NUMBER 188
DTYEIYM NUMBER 189
DTYEIDS NUMBER 190
???
QMXQRS_JCONF_XQ_PUSHDOWN NUMBER 1
QMXQRS_JCONF_VAR_AS_EXTL NUMBER 2
QMXQRS_JCONF_EXTL_FUNC_LAX NUMBER 4
QMXQRS_JCONF_NO_XP_PUSHDOWN NUMBER 8
QMXQRS_JCONF_NO_STATIC_TYPING NUMBER 16
QMXQRS_JCONF_ENABLE_LAZY_DOM NUMBER 32
Dependencies
DUAL V$NLS_PARAMETERS XMLTYPE
Documented No
First Available 11.2.0.1
Security Model Owned by SYS with EXECUTE granted to PUBLIC
Source {ORACLE_HOME}/rdbms/admin/initxqry.sql
Subprograms
 
BIND
Undocumented dbms_xqueryint.bind(
hdl    IN NUMBER,
name   IN VARCHAR2,
flags  IN NUMBER,
xctx   IN CLOB,
schema IN VARCHAR2);
TBD
 
BINDWITHTYPE
Undocumented dbms_xqueryint.bindWithType(
hdl    IN NUMBER,
name   IN VARCHAR2,
flags  IN NUMBER,
xctx   IN CLOB,
schema IN VARCHAR2,
xqtype IN NUMBER);
TBD
 
BINDXML
Undocumented dbms_xqueryint.bindXML(
hdl  IN NUMBER,
name IN VARCHAR2,
xctx IN sys.xmltype)
RETURN NUMBER AS LANGUAGE JAVA NAME 'oracle.xquery.OXQServer.bindXML(int, java.lang.String, oracle.xdb.XMLType)
RETURN INT';
TBD
 
CLOSEHDL
Undocumented dbms_xqueryint.closeHDL(hdl IN NUMBER);
TBD
 
EXEC
Undocumented dbms_xqueryint.exec(
hdl    IN NUMBER,
retseq IN NUMBER)
RETURN sys.xmltype PARALLEL_ENABLE;
TBD
 
EXECALL
Undocumented dbms_xqueryint.execAll(
xqry   IN     VARCHAR2,
nlssrt IN     VARCHAR2,
nlscmp IN     VARCHAR2,
dbchr  IN     VARCHAR2,
retseq IN     NUMBER,
flags  IN     NUMBER,
hdl    IN OUT NUMBER)
RETURN sys.xmltype PARALLEL_ENABLE;
TBD
 
EXECALLCMN
Undocumented dbms_xqueryint.execAllCmn(
xqry     IN     VARCHAR2,
nlssrt   IN     VARCHAR2,
nlscmp   IN     VARCHAR2,
dbchr    IN     VARCHAR2,
retseq   IN     NUMBER,
flags    IN     NUMBER,
xqryclb  IN     CLOB,
xqisCLOB IN     NUMBER,
hdl      IN OUT NUMBER)
RETURN sys.xmltype;
TBD
 
EXECALLXCLB
Undocumented dbms_xqueryint.execAllXCLB(
xqryclb IN     CLOB,
nlssrt  IN     VARCHAR2,
nlscmp  IN     VARCHAR2,
dbchr   IN     VARCHAR2,
retseq  IN     NUMBER,
flags   IN     NUMBER,
hdl     IN OUT NUMBER)
RETURN sys.xmltype PARALLEL_ENABLE;
TBD
 
EXECALLXCLB_EXISTS
XMLExists Support dbms_xqueryint.execAllXCLB_exists(
xqryclb IN     CLOB,
nlssrt  IN     VARCHAR2,
nlscmp  IN     VARCHAR2,
dbchr   IN     VARCHAR2,
retseq  IN     NUMBER,
flags   IN     NUMBER,
hdl     IN OUT NUMBER)
RETURN NUMBER;
TBD
 
EXECALL_EXISTS
XMLExists Support dbms_xqueryint.execAll_exists(
xqry   IN     VARCHAR2,
nlssrt IN     VARCHAR2,
nlscmp IN     VARCHAR2,
dbchr  IN     VARCHAR2,
retseq IN     NUMBER,
flags  IN     NUMBER,
hdl    IN OUT NUMBER)
RETURN NUMBER;
TBD
 
EXECQUERY
Undocumented dbms_xqueryint.execQuery(hdl IN NUMBER);
TBD
 
EXECUTE
Undocumented dbms_xqueryint.execute(
xqry   IN VARCHAR2,
xctx   IN xmltype := NULL,
retseq IN NUMBER  := 0)
RETURN sys.xmltype PARALLEL_ENABLE;
TBD
 
EXECUTECMN
Undocumented dbms_xqueryint.executeCmn(
xqry     IN VARCHAR2,
xctx     IN xmltype := NULL,
retseq   IN NUMBER  := 0,
xqryclb  IN CLOB,
xqisCLOB IN NUMBER)
RETURN sys.xmltype PARALLEL_ENABLE;
TBD
 
EXECUTEXCLB
Undocumented dbms_xqueryint.executeCLB(
xqry   IN CLOB,
xctx   IN xmltype := NULL,
retseq IN NUMBER  := 0)
RETURN sys.xmltype PARALLEL_ENABLE;
TBD
 
EXEC_EXISTS
XMLExists Support dbms_xqueryint.exec_exists(
hdl    IN NUMBER,
retseq IN NUMBER)
RETURN NUMBER;
TBD
 
FETCHALL
Undocumented dbms_xqueryint.fetchAll(
hdl IN NUMBER,
xctx  IN OUT CLOB,
flags IN OUT NUMBER)
RETURN NUMBER;
TBD
 
FETCHONE
Undocumented dbms_xqueryint.fetchOne(
hdl    IN     NUMBER,
xctx   IN OUT CLOB,
flags  IN OUT NUMBER,
str       OUT VARCHAR2,
xqtype IN OUT NUMBER)
RETURN NUMBER;
TBD
 
GETXQUERYX
Undocumented dbms_xqueryint.getXQueryX(xqry IN VARCHAR2)
RETURN CLOB PARALLEL_ENABLE;
TBD
 
GETXQUERYXXCLB
Undocumented dbms_xqueryint.getQueryXXCLB(xqry IN CLOB)
RETURN CLOB PARALLEL_ENABLE;
TBD
 
PREPARE
Undocumented dbms_xqueryint.prepare(
xqry   IN VARCHAR2,
nlssrt IN VARCHAR2,
nlscmp IN VARCHAR2,
dbchr  IN VARCHAR2,
flags  IN NUMBER)
RETURN NUMBER;
TBD
 
PREPAREXCLB
Undocumented dbms_xqueryint.prepareXCLB(
xqry   IN CLOB,
nlssrt IN VARCHAR2,
nlscmp IN VARCHAR2,
dbchr  IN VARCHAR2,
flags  IN NUMBER)
RETURN NUMBER;
TBD

Related Topics
Built-in Functions
Built-in Packages
DBMS_XQUERY
What's New In 18cR3
What's New In 19cR2
XMLQUERY

Morgan's Library Page Footer
This site is maintained by Dan Morgan. Last Updated: This site is protected by copyright and trademark laws under U.S. and International law. © 1998-2019 Daniel A. Morgan All Rights Reserved
DBSecWorx