| General Information |
| Source |
{ORACLE_HOME}/rdbms/admin/dbmsxdb.sql |
| Constants |
| Constant |
Data Type |
Usage |
| DELETE_RESOURCE |
NUMBER |
1 |
| DELETE_RECURSIVE |
NUMBER |
2 |
| DELETE_FORCE |
NUMBER |
3 |
| DELETE_RECURSIVE_FORCE |
NUMBER |
4 |
| |
| DELETE_RES_METADATA_CASCADE |
NUMBER |
1 |
| DELETE_RES_METADATA_NOCASCADE |
NUMBER |
2 |
| -- Constant number for 1st argument of setListenerEndPoint |
| XDB_ENDPOINT_HTTP |
NUMBER |
1 |
| XDB_ENDPOINT_HTTP2 |
NUMBER |
2 |
| -- Constant number for 4th argument of setListenerEndPoint |
| XDB_PROTOCOL_TCP |
NUMBER |
1 |
| XDB_PROTOCOL_TCPS |
NUMBER |
2 |
| |
| DEFAULT_LOCK_TIMEOUT |
PLS_INTEGER |
(60*60) |
| |
| LINK_TYPE_HARD |
NUMBER |
1 |
| LINK_TYPE_WEAK |
NUMBER |
2 |
| LINK_TYPE_SYMBOLIC |
NUMBER |
3 |
| |
| ON_DENY_NEXT_CUSTOM |
NUMBER |
1 |
| ON_DENY_BASIC |
NUMBER |
2 |
|
| Dependencies |
| AWM_CREATEXDSFOLDER |
DBMS_XDBRESOURCE |
DUAL |
| DBMS_ASSERT |
DBMS_XDBT |
GET_XDB_TABLESPACE |
| DBMS_CUBE_EXP |
DBMS_XDBUTIL_INT |
LOCKTOKENLISTTYPE |
| DBMS_EPG |
DBMS_XDBZ |
SET_TABLESPACE |
| DBMS_LOB |
BMS_XDB_LIB |
XMLTYPE |
| DBMS_NETWORK_ACL_ADMIN |
DBMS_XMLDOM |
|
|
| Security Model |
Owned by XDB with execute granted to PUBLIC |
| Subprograms |
|
| |
| 82 Separate Named Objects |
| Not adding to this page at this time due to more pressing work. |
dbms_xdb.... |
| TBD |
| |
| ACLCHECKPRIVILEGES |
| Checks the access privileges granted by specified ACL document |
dbms_xdb.ACLCheckPrivileges(
acl_path IN VARCHAR2,
owner IN VARCHAR2,
privs IN XMLTYPE)
RETURN PLS_INTEGER; |
| TBD |
| |
| GETFTPPORT |
| Gets the FTP Port |
dbms_xdb.getFTPPort RETURN NUMBER; |
SELECT dbms_xdb.getFTPPort
FROM dual;
GETFTPPORT
----------
0
exec dbms_xdb.setFTPPort(20);
SELECT dbms_xdb.getFTPPort
FROM dual;
GETFTPPORT
----------
20 |
| |
| GETHTTPPORT |
| Returns the HTMLDB Port |
dbms_xdb.getHTTPPort; |
SELECT dbms_xdb.getHTTPPort
FROM DUAL;
GETHTTPPORT
-----------
8080 |
| |
| GETHTTPREQUESTHEADER |
| Returns the values of the passed header if called during an HTTP request |
dbms_xdb.getHTTPRequestHeader(header_name IN VARCHAR2) RETURN VARCHAR2; |
set serveroutput on
DECLARE
rqhdr VARCHAR2(100);
BEGIN
rqhdr := dbms_xdb.getHTTPRequestHeader('UWHeader');
dbms_output.put_line(rqhdr);
END;
/ |
| |
| GETLISTENERENDPOINT |
Retrieves the parameters of a listener end point corresponding to the XML DB HTTP server. The parameters of both HTTP
and HTTP2 end points can be retrieved by invoking this procedure. |
dbms_xdb.getListenerEndPoint(
endpoint IN NUMBER,
host OUT VARCHAR2,
port OUT NUMBER,
protocol OUT NUMBER); |
| TBD |
| |
| SETDEFAULTTYPEMAPPINGS |
| Sets the value of default-type-mappings in xdbconfig |
dbms_xdb.setDefaultTypeMappings(setDefaultTypeMappings(version IN VARCHAR2); |
| TBD |
| |
| SETFTPPORT |
| Sets the FTP Port |
dbms_xdb.setFTPPort(newport IN NUMBER); |
| See getFTPPort demo above |
| |
| SETHTTPPORT |
| Sets the HTMLDB Port |
dbms_xdb.setHTTPPort(newport IN NUMBER); |
exec dbms_xdb.setHTTPPort(8080);
COMMIT; |
| |
| SETLISTENERENDPOINT |
| Sets the parameters of a listener end point corresponding to the XML DB HTTP server.
Both HTTP and HTTP2 end points can be set by invoking this procedure |
dbms_xdb.setListenerEndPoint(
endpoint IN NUMBER,
host IN VARCHAR2,
port IN NUMBER,
protocol IN NUMBER); |
| TBD |
| |
| SETLISTENERLOCALACCESS |
| Restricts listener end points of the XML DB HTTP server to listen only on the localhost interface if TRUE or to all listener end points if FALSE |
dbms_xdb.setListenerLocalAccess(l_access IN BOOLEAN); |
| exec dbms_xdb.setListenerLocalAccess(TRUE); |
