December 2002
Intermediate to advanced
928 pages
85h 29m
English
PROCEDURE DBMS_DEFER.CALL
(schema_name IN VARCHAR2,
package_name IN VARCHAR2,
proc_name IN VARCHAR2,
arc_count IN NATURAL,
{node IN node_list_t | group_name IN VARCHAR DEFAULT ''});
Builds a deferred call to a remote procedure. The last parameter was new with Oracle8i.
PROCEDURE DBMS_DEFER.COMMIT_WORK
(commit_work_comment IN VARCHAR2);
Performs a transaction commit after checking for well-formed deferred remote procedure calls.
PROCEDURE DBMS_DEFER.datatype_ARG
(arg IN datatype);
Specifies datatype for parameters. Used after the DBMS_DEFER.CALL procedure.
PROCEDURE DBMS_DEFER.TRANSACTION
(nodes IN node_list_t);
where nodes is a list of fully qualified database names to which you want to propagate the deferred transactions.