Oracle | DBMS_PRVTAQIP

Oracle DBMS_PRVTAQIP Version 26ai

General Information

Library Note

Morgan's Library Page Header

The best Oracle News for FY2026

Oracle Database 26ai will be available on generic Linux platforms in January and soon on AIX and Windows

Purpose Advanced Queuing Utilities (a substantial percentage of the subprograms are likely deprecated)

AUTHID DEFINER

Constants

Name	Data Type	Value
Constants found in execaq.sql used by DBMS_SCHEDULER.DEFINE_PROGRAM_ARGUMENT
DEFAULT_DEQUEUE_TIMEOUT	Not Known	100
DEFAULT_IDLE_TIMEOUT	Not Known	240
DEFAULT_TRACE_LEVEL	Not Known	0

Dependencies SELECT name FROM dba_dependencies WHERE referenced_name = 'DBMS_PRVTAQIP' UNION SELECT referenced_name FROM dba_dependencies WHERE name = 'DBMS_PRVTAQIP' ORDER BY 1;

Returns 54 objects

Documented No

First Available Not known but likely 10.2

Security Model Owned by SYS with no privileges granted

Source {ORACLE_HOME}/rdbms/admin/dbmsaqds.plb
{ORACLE_HOME}/rdbms/admin/prvtaqip.plb

Subprograms

ALTER_PROPAGATION_SCHEDULE	HTTP_COMMIT	TRUNCATE_PENDING_MESSAGES
CREATE_PROP_TABLE_102	HTTP_PUSH	TYPE_MATCHES
CRT_XMLCMT_REQ	HTTP_ROLLBACK	UPDATE_AQS_INSTANCE_102
CRT_XMLRBK_REQ	IS_PROTO_SSL	UPDATE_PROPAGATION_REPL
CRT_XMLSEQ_REQ	I_UNSCHED_PROP	UPDATE_PROPJOB_AFFINITY_102
CRT_XMLTYP_REQ	KWQP_3GL_MODPSENTRY	UPDATE_PROP_STATUS
DELETE_PENDING_MESSAGES	NEEDS_RECOVERY	UPDATE_SCHEDULE
DEQ_NFY_QUEUE_102	RECOVER_PROPAGATION	UPDATE_SCHEDULE_CLEAR_ERROR
DISABLE_PROPAGATION_SCHEDULE	RECOVER_PROPAGATION_INT	UPDATE_SCHEDULE_INT
ENABLE_PROPAGATION_SCHEDULE	RESUBMIT_JOBS_102	UPDATE_SCHEDULE_REPL
ENQ_NFY_QUEUE_102	SCHEDULE_PROPAGATION	WRITE_REQUEST
GET_SCHED_TYPE	TRANS_SCHED_INFO	WRITE_TRACE
GET_SEQNO_HTTP

ALTER_PROPAGATION_SCHEDULE

Undocumented dbms_prvtaqip.alter_propagation_schedule( queue_name IN VARCHAR2, destination IN VARCHAR2, duration IN NUMBER, next_time IN VARCHAR2, latency IN NUMBER, qname IN VARCHAR2, myoid IN RAW, canon_dest IN VARCHAR2, current_user IN VARCHAR2);

TBD

CREATE_PROP_TABLE_102

Undocumented dbms_prvtaqip.create_prop_102( qname IN VARCHAR2, instance_num IN NUMBER, check_compatible IN BOOLEAN);

TBD

CRT_XMLCMT_REQ

Undocumented dbms_prvtaqip.crt_xmlcmt_req(request OUT VARCHAR2);

DECLARE

       outVal dbms_id;

      BEGIN

        dbms_prvtaqip.crt_xmlcmt_req(outVal);

        dbms_output.put_line(outVal);

      END;

      /

CRT_XMLRBK_REQ

Undocumented dbms_prvtaqip.crt_xmlrbk_req(request OUT VARCHAR2);

DECLARE

       outVal dbms_id;

      BEGIN

        dbms_prvtaqip.crt_xmlrbk_req(outVal);

        dbms_output.put_line(outVal);

      END;

      /

CRT_XMLSEQ_REQ

Undocumented dbms_prvtaqip.crt_xmlseq_req( dblink IN VARCHAR2, queue IN VARCHAR2, qid IN NUMBER, request OUT VARCHAR2);

TBD

CRT_XMLTYP_REQ

Undocumented dbms_prvtaqip.crt_xmltyp_req( queue IN VARCHAR2, request OUT VARCHAR2);

TBD

DELETE_PENDING_MESSAGES (new 23ai)

Undocumented dbms_prvtaqip.delete_pending_messages( minsec IN NUMBER, delsec IN NUMBER, trace IN NUMBER);

TBD

DEQ_NFY_QUEUE_102

Undocumented dbms_prvtaqip.deq_nfy_queue_102( recipient IN VARCHAR2, instance IN NUMBER, incorrid IN VARCHAR2, wait IN BINARY_INTEGER, opcode OUT NUMBER, qid OUT RAW, dest OUT VARCHAR2, destl OUT NUMBER, outcorrid OUT VARCHAR2, outcorridl OUT NUMBER, msgfound OUT NUMBER);

TBD

DISABLE_PROPAGATION_SCHEDULE

Undocumented dbms_prvtaqip.disable_propagation_schedule( queue_schema IN VARCHAR2, queue_name IN VARCHAR2, destination IN VARCHAR2, myoid IN RAW, canon_dest IN VARCHAR2);

TBD

ENABLE_PROPAGATION_SCHEDULE

Undocumented dbms_prvtaqip.enable_propagation_schedule( queue_schema IN VARCHAR2, queue_name IN VARCHAR2, destination IN VARCHAR2, myoid IN RAW, canon_dest IN VARCHAR2);

TBD

ENQ_NFY_QUEUE_102

Undocumented dbms_prvtaqip.enq_nfy_queue_102( recipient IN VARCHAR2, instance IN NUMBER, opcode IN NUMBER, qid IN RAW, dest IN VARCHAR2, corrid IN VARCHAR2, expiration IN BINARY_INTEGER);

TBD

GET_SCHED_TYPE

Undocumented dbms_prvtaqip.get_sched_type( qt_flags IN BINARY_INTEGER, start_time IN DATE, duration IN NUMBER, latency IN NUMBER, next_time IN VARCHAR2);

TBD

GET_SEQNO_HTTP

Undocumented =dbms_prvtaqip.get_seqno_http( url IN VARCHAR2, username IN VARCHAR2, passwd IN VARCHAR2, dest IN VARCHAR2, queue IN VARCHAR2, qid IN NUMBER, trace IN BINARY_INTEGER, status_code OUT NUMBER, remoteseq OUT NUMBER);

TBD

HTTP_COMMIT

Undocumented dbms_prvtaqip.http_commit( url IN VARCHAR2, username IN VARCHAR2, passwd IN VARCHAR2, trace IN BINARY_INTEGER);

TBD

HTTP_PUSH

Undocumented dbms_prvtaqip.http_push( url IN VARCHAR2, username IN VARCHAR2, passwd IN VARCHAR2, trace IN BINARY_INTEGER, resp OUT VARCHAR2, xmldoc IN CLOB);

TBD

HTTP_ROLLBACK

Undocumented dbms_prvtaqip.http_rollback( url IN VARCHAR2, username IN VARCHAR2, passwd IN VARCHAR2, trace IN BINARY_INTEGER);

TBD

IS_PROTO_SSL

Undocumented dbms_prvtaqip.is_proto_ssl(url IN VARCHAR2) RETURN BOOLEAN;

TBD

I_UNSCHED_PROP

Undocumented dbms_prvtaqip.i_unsched_prop( myoid IN RAW, queue_schema IN VARCHAR2, queue_name IN VARCHAR2, canon_dest IN VARCHAR2, synchronous IN BOOLEAN, propagation_name IN VARCHAR2) RETURN BINARY_INTEGER;

TBD

KWQP_3GL_MODPSENTRY

Undocumented dbms_prvtaqip.kwqp_3gl_modsentry( operation IN BINARY_INTEGER, qid IN NUMBER, queue_schema IN VARCHAR2, queue_name IN VARCHAR2, destination IN VARCHAR2, job_name IN VARCHAR2, prop_name IN VARCHAR2, queue_to_queue IN BOOLEAN);

TBD

NEEDS_RECOVERY

Undocumented dbms_prvtaqip.needs_recovery( schema IN VARCHAR2, qtname IN VARCHAR2) RETURN BOOLEAN;

TBD

RECOVER_PROPAGATION

Undocumented dbms_prvtaqip.recover_propagation( schema IN VARCHAR2, qname IN VARCHAR2, dest IN VARCHAR2, protocol IN BINARY_INTEGER, url IN VARCHAR2, username IN VARCHAR2, passwd IN VARCHAR2, trace IN BINARY_INTEGER, destq IN BINARY_INTEGER, current_user IN VARCHAR2);

TBD

RECOVER_PROPAGATION_INT (new 23ai)

Undocumented dbms_prvtaqip.recover_propagation_int( schema IN VARCHAR2, qname IN VARCHAR2, qid IN NUMBER, qoid IN RAW, qtname IN VARCHAR2, dest IN VARCHAR2, prop_id IN RAW, remotedb IN VARCHAR2, DESTINATIONQ IN VARCHAR2, localseq IN NUMBER, remoteseq IN NUMBER, num_msgs IN OUT NUMBER, rec_time IN OUT DATE, issharded IN BOOLEAN, shrdid IN BINARY_INTEGER, trace IN BINARY_INTEGER, current_user IN VARCHAR2)

TBD

RESUBMIT_JOBS_102

Undocumented dbms_prvtaqip.resubmit_jobs_102(job IN NUMBER);

exec dbms_prvtaqip.resubmit_jobs_102(42);

      

      PL/SQL procedure successfully completed.

SCHEDULE_PROPAGATION

Undocumented dbms_prvtaqip.schedule_propagation( queue_schema IN VARCHAR2, queue_name IN VARCHAR2, destination IN VARCHAR2, start_time IN TIMESTAMP WITH TIME ZONE duration IN NUMBER, next_time IN VARCHAR2, latency IN NUMBER, myoid IN RAW, canon_dest IN VARCHAR2, destinationq IN BOOLEAN, propagation_name IN VARCHAR2);

TBD

TRANS_SCHED_INFO

Undocumented dbms_prvtaqip.trans_sched_info( qid IN RAW, dest IN VARCHAR2, sess_id IN NUMBER, sess_serial IN NUMBER, schema OUT VARCHAR2, schemal OUT NUMBER, qname OUT VARCHAR2, qnamel OUT NUMBER, p_start_time OUT DATE duration OUT NUMBER, durationind OUT NUMBER, next_time OUT VARCHAR2, lnext_time OUT NUMBER, latency OUT NUMBER, latencyind OUT NUMBER, toid OUT RAW, toidind OUT NUMBER, version OUT NUMBER, schedind OUT NUMBER, qusage OUT NUMBER, qeventid OUT NUMBER, http_batchsz OUT NUMBER, err_msg OUT NUMBER);

TBD

TRUNCATE_PENDING_MESSAGES

Undocumented dbms_prvtaqip.truncate_pending_messages;

exec dbms_prvtaqip.truncate_pending_messages;

      

      PL/SQL procedure successfully completed.

TYPE_MATCHES

Undocumented dbms_prvtaqip.type_matches( qoid IN RAW, address IN VARCHAR2, dest IN VARCHAR2) RETURN BOOLEAN;

TBD

UPDATE_AQS_INSTANCE_102

Undocumented dbms_prvtaqip.update_aqs_instance_102;

exec dbms_prvtaqip.update_aqs_instance_102;

      

      PL/SQL procedure successfully completed.

UPDATE_PROPAGATION_REPL (new 23ai)

Undocumented dbms_prvtaqip.update_propagation_repl( schema IN VARCHAR2, qname IN VARCHAR2, dest IN VARCHAR2, prop_id IN RAW, remotedb IN VARCHAR2, destinationq IN VARCHAR2, seq1 IN NUMBER, seq2 IN NUMBER, num_msgs IN NUMBER, rec_time IN DATE, shrdid IN BINARY_INTEGER, current_user IN VARCHAR2, action IN BINARY_INTEGER);

TBD

UPDATE_PROPJOB_AFFINITY_102

Undocumented dbms_prvtaqip.update_propjob_affinity_102( qtableno IN NUMBER, newinstance IN NUMBER);

TBD

UPDATE_PROP_STATUS (new 23ai)

Undocumented dbms_prvtaqip.update_prop_status( qname IN VARCHAR2, dest_qid IN NUMBER, destination IN VARCHAR2, prop_id IN RAW, shard_id IN NUMBER, status IN NUMBER, sequence IN NUMBER, msgids IN sys.aq$_ntfn_msgid_array, prop-msgids IN sys.aq$_ntfn_msgid_array);

TBD

UPDATE_SCHEDULE

Undocumented dbms_prvtaqip.update_schedule( prop_time IN NUMBER, msgs IN NUMBER, bytes IN NUMBER, err_msg IN VARCHAR2, schema IN VARCHAR2, qname IN VARCHAR2, qid IN RAW, dest IN VARCHAR2, force IN NUMBER, trace IN NUMBER, http_batchsz IN NUMBER, continue_prop OUT NUMBER, schedind OUT NUMBER, gnoreerr IN NUMBER, propstyle102 IN NUMBER);

TBD

UPDATE_SCHEDULE_CLEAR_ERROR

Undocumented dbms_prvtaqip.update_schedule_clear_error( qid IN RAW, dest IN VARCHAR2, jobno IN NUMBER);

TBD

UPDATE_SCHEDULE_INT (new 23ai)

Undocumented dbms_prvtaqip.update_schedule_int( quid IN RAW, dest IN VARCHAR2, prop_id IN RAW, shardid IN BINARY_INTEGER, inst_id IN NUMBER, issharded IN BOOLEAN, mytime IN NUMBER, mymsgs IN NUMBER, mybytes IN NUMBER, mywindows IN NUMBER, winmsgs IN NUMBER, winbytes IN NUMBER, mylasttime IN DATE, mydisabled IN VARCHAR2, maxwinmsgs IN NUMBER, maxwinbytes IN NUMBER, myfailures IN NUMBER, myerrtime IN DATE, myerrmsg IN VARCHAR2);

TBD

UPDATE_SCHEDULE_REPL (new 23ai)

Undocumented dbms_prvtaqip.update_schedule_repl( schema IN VARCHAR2, qname IN VARCHAR2, dest IN VARCHAR2, prop_id IN RAW, shard_id IN BINARY_INTEGER, prop_time IN NUMBER, nmsgs IN NUMBER, bytes IN NUMBER, windows IN NUMBER, winmsgs IN NUMBER, winbytes IN NUMBER, lasttime IN DATE, disabled IN VARCHAR2, myfailures IN NUMBER, myerrtime IN DATE, myerrmsg IN VARCHAR2);

TBD

WRITE_REQUEST

Undocumented dbms_prvtaqip.write_request( request IN OUT sys.utl_http.req, xmldoc IN CLOB);

TBD

WRITE_TRACE

Undocumented dbms_prvtaqip.write_trace( trace_level IN BINARY_INTEGER, level IN BINARY_INTEGER, message IN VARCHAR2);

TBD