Oracle DBMS_XQUERYINT
Version 19.3

General Information
Library Note Morgan's Library Page Header
Which has the higher priority in your organization: Deploying a new database or securing the ones you already have? Looking for a website, and resources, dedicated solely to securing Oracle databases? Check out DBSecWorx.
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 18c
What's New In 19c
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