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
QMTXT_XDT_ANYATOMICTYPE
NUMBER
48
QMTXT_XDT_UNTYPEDANY
NUMBER
49
QMTXT_XDT_UNTYPEDATOMIC
NUMBER
50
QMTXT_XDT_DAYTIMEDURATION
NUMBER
51
QMTXT_XDT_YEARMONTHDURATION
NUMBER
52
XDT Basic Types: Type Ending
QMTXT_INVALIDTYPE
NUMBER
255
dtydef.h Constants
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
XDT basic types for XQuery Primitive Types
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