| General Information |
| Source |
{ORACLE_HOME}/rdbms/admin/prvtaqxi.plb |
| First Available |
11.2.0.1 |
| Dependencies |
| DBMS_AQ_EXP_ZECURITY |
DBMS_AQ_SYS_EXP_ACTIONS |
|
| Security Model |
Owned by SYS with execute granted to PUBLIC |
| |
| INSTANCE_INFO_EXP |
| Undocumented |
dbms_aq_exp_cmt_time_tables(
name IN VARCHAR2,
schema IN VARCHAR2,
prepost IN BINARY_INTEGER,
isdba IN BINARY_INTEGER,
version IN VARCHAR2,
new_block OUT BINARY_INTEGER)
RETURN VARCHAR2; |
SELECT owner, table_name, type
FROM dba_queue_tables
ORDER BY 1,2;
set serveroutput on
DECLARE
nblk BINARY_INTEGER;
RetVal VARCHAR2(4096);
BEGIN
RetVal := dbms_aq_exp_dequeuelog_tables.instance_info_exp('AQ_EVENT_TABLE', 'SYS', 1, 1, '11.2.0.2.0', nblk);
dbms_output.put_line('New Block: ' || TO_CHAR(nblk));
dbms_output.put_line('Return Value: ' || RetVal);
END;
/ |
|
