Procedures/Functions
add_alias_to_ldap
procedure add_alias_to_ldap (
alias in varchar2 ,
obj_location in varchar2
);
add_connection_to_ldap
procedure add_connection_to_ldap (
connection in varchar2 ,
host in varchar2 ,
port in binary_integer ,
sid in varchar2 ,
driver in varchar2 default,
type in binary_integer default
);
procedure add_connection_to_ldap (
connection in varchar2 ,
jdbc_string in varchar2 ,
username in varchar2 default,
password in varchar2 default,
type in binary_integer default
);
add_subscriber
procedure add_subscriber (
queue_name in varchar2 ,
subscriber in aq$_agent ,
rule in varchar2 default,
transformation in varchar2 default
);
alter_aq_agent
procedure alter_aq_agent (
agent_name in varchar2 ,
certificate_location in varchar2 default,
enable_http in boolean default,
enable_smtp in boolean default,
enable_anyp in boolean default
);
alter_propagation_schedule
procedure alter_propagation_schedule (
queue_name in varchar2 ,
destination in varchar2 default,
duration in number default,
next_time in varchar2 default,
latency in number default
);
alter_queue
procedure alter_queue (
queue_name in varchar2 ,
max_retries in number default,
retry_delay in number default,
retention_time in number default,
auto_commit in boolean default,
comment in varchar2 default
);
alter_queue_table
procedure alter_queue_table (
queue_table in varchar2 ,
comment in varchar2 default,
primary_instance in binary_integer default,
secondary_instance in binary_integer default
);
alter_subscriber
procedure alter_subscriber (
queue_name in varchar2 ,
subscriber in aq$_agent ,
rule in varchar2
);
procedure alter_subscriber (
queue_name in varchar2 ,
subscriber in aq$_agent ,
rule in varchar2 ,
transformation in varchar2 ,
job in number ,
job in number ,
next_date in date ,
qname in varchar2 ,
schema in varchar2 ,
destination in varchar2 default,
toid_char in varchar2 default,
version_char in varchar2 default,
start_time in varchar2 ,
duration in varchar2 default,
next_time in varchar2 default,
latency in varchar2 default
);
create_aq_agent
procedure create_aq_agent (
agent_name in varchar2 ,
certificate_location in varchar2 default,
enable_http in boolean default,
enable_smtp in boolean default,
enable_anyp in boolean default
);
create_np_queue
procedure create_np_queue (
queue_name in varchar2 ,
multiple_consumers in boolean default,
comment in varchar2 default
);
create_queue
procedure create_queue (
queue_name in varchar2 ,
queue_table in varchar2 ,
queue_type in binary_integer default,
max_retries in number default,
retry_delay in number default,
retention_time in number default,
dependency_tracking in boolean default,
comment in varchar2 default,
auto_commit in boolean default
);
create_queue_table
procedure create_queue_table (
queue_table in varchar2 ,
queue_payload_type in varchar2 ,
storage_clause in varchar2 default,
sort_list in varchar2 default,
multiple_consumers in boolean default,
message_grouping in binary_integer default,
comment in varchar2 default,
auto_commit in boolean default,
primary_instance in binary_integer default,
secondary_instance in binary_integer default,
compatible in varchar2 default,
non_repudiation in binary_integer default,
secure in boolean default
);
del_alias_from_ldap
procedure del_alias_from_ldap (
alias in varchar2
);
del_connection_from_ldap
procedure del_connection_from_ldap (
connection in varchar2
);
disable_db_access
procedure disable_db_access (
agent_name in varchar2 ,
db_username in varchar2
);
disable_propagation_schedule
procedure disable_propagation_schedule (
queue_name in varchar2 ,
destination in varchar2 default
);
drop_aq_agent
procedure drop_aq_agent (
agent_name in varchar2
);
drop_queue
procedure drop_queue (
queue_name in varchar2 ,
auto_commit in boolean default
);
drop_queue_table
procedure drop_queue_table (
queue_table in varchar2 ,
force in boolean default,
auto_commit in boolean default
);
enable_db_access
procedure enable_db_access (
agent_name in varchar2 ,
db_username in varchar2
);
enable_jms_types
procedure enable_jms_types (
queue_table in varchar2
);
enable_propagation_schedule
procedure enable_propagation_schedule (
queue_name in varchar2 ,
destination in varchar2 default
);
get_type_info
procedure get_type_info (
schema in varchar2 ,
qname in varchar2 ,
gettds in boolean ,
rc out binary_integer ,
toid out raw ,
version out number ,
tds out long raw ,
queue_style out varchar2
);
procedure get_type_info (
schema in varchar2 ,
qname in varchar2 ,
gettds in boolean ,
rc out binary_integer ,
toid out raw ,
version out number ,
tds out long raw
);
get_watermark
procedure get_watermark (
wmvalue out number
);
grant_queue_privilege
procedure grant_queue_privilege (
privilege in varchar2 ,
queue_name in varchar2 ,
grantee in varchar2 ,
grant_option in boolean default
);
grant_system_privilege
procedure grant_system_privilege (
privilege in varchar2 ,
grantee in varchar2 ,
admin_option in boolean default
);
grant_type_access
procedure grant_type_access (
user_name in varchar2
);
migrate_queue_table
procedure migrate_queue_table (
queue_table in varchar2 ,
compatible in varchar2
);
nonrepudiate_receiver
procedure nonrepudiate_receiver (
queue_name in varchar2 ,
msgid in raw ,
rcver_info in aq$_agent ,
signature out aq$_sig_prop ,
payload out standard
);
procedure nonrepudiate_receiver (
queue_name in varchar2 ,
msgid in raw ,
rcver_info in aq$_agent ,
signature out aq$_sig_prop ,
payload out raw
);
nonrepudiate_sender
procedure nonrepudiate_sender (
queue_name in varchar2 ,
msgid in raw ,
sender_info in aq$_agent ,
signature out aq$_sig_prop ,
payload out standard
);
procedure nonrepudiate_sender (
queue_name in varchar2 ,
msgid in raw ,
sender_info in aq$_agent ,
signature out aq$_sig_prop ,
payload out raw
);
purge_queue_table
procedure purge_queue_table (
queue_table in varchar2 ,
purge_condition in varchar2 ,
purge_options in record
);
queue_subscribers
function queue_subscribers returns table of aq$_agent (
queue_name in varchar2
);
recover_propagation
procedure recover_propagation (
schema in varchar2 ,
queue_name in varchar2 ,
destination in varchar2 ,
protocol in binary_integer default,
url in varchar2 default,
username in varchar2 default,
passwd in varchar2 default,
trace in binary_integer default
);
remove_subscriber
procedure remove_subscriber (
queue_name in varchar2 ,
subscriber in aq$_agent
);
revoke_queue_privilege
procedure revoke_queue_privilege (
privilege in varchar2 ,
queue_name in varchar2 ,
grantee in varchar2
);
revoke_system_privilege
procedure revoke_system_privilege (
privilege in varchar2 ,
grantee in varchar2
);
schedule_propagation
procedure schedule_propagation (
queue_name in varchar2 ,
destination in varchar2 default,
start_time in date default,
duration in number default,
next_time in varchar2 default,
latency in number default
);
set_session_event
procedure set_session_event (
eventno in varchar2 ,
tracelevel in varchar2
);
set_watermark
procedure set_watermark (
wmvalue in number
);
start_queue
procedure start_queue (
queue_name in varchar2 ,
enqueue in boolean default,
dequeue in boolean default
);
start_time_manager
procedure start_time_manager (
);
stop_queue
procedure stop_queue (
queue_name in varchar2 ,
enqueue in boolean default,
dequeue in boolean default,
wait in boolean default
);
stop_time_manager
procedure stop_time_manager (
);
unschedule_propagation
procedure unschedule_propagation (
queue_name in varchar2 ,
destination in varchar2 default
);
verify_queue_types
procedure verify_queue_types (
src_queue_name in varchar2 ,
dest_queue_name in varchar2 ,
destination in varchar2 default,
rc out binary_integer ,
transformation in varchar2 default
);
verify_queue_types_get_nrp
procedure verify_queue_types_get_nrp (
src_queue_name in varchar2 ,
dest_queue_name in varchar2 ,
destination in varchar2 default,
rc out binary_integer ,
transformation in varchar2 default
);
verify_queue_types_no_queue
procedure verify_queue_types_no_queue (
src_queue_name in varchar2 ,
dest_queue_name in varchar2 ,
destination in varchar2 default,
rc out binary_integer ,
transformation in varchar2 default
);
|