Oracle Distributed Systems

Name

DBMS_DEFER.CALL

Synopsis

The CALL procedure queues an RPC to the destination specified in the DEFDEFAULTDEST data dictionary view. It calls TRANSACTION automatically if it is the first call of a transaction. If you do not specify a value for the nodes parameter, the destination of the RPC will be the locations in the data dictionary view DEFDEFAULTDEST.

PROCEDURE DBMS_DEFER.CALL
  (schema_name IN VARCHAR2,
   package_name IN VARCHAR2,
   proc_name IN VARCHAR2,
   arg_count IN NATURAL,
   {group_name IN VARCHAR2 := ''| 
   nodes IN node_list_t});

Parameters

Parameter Name	Description
schema_name	Name of the schema queuing the call.
package_name	Name of the package containing the procedure that is being queued.
proc_name	Name of the procedure being queued.
arg_count	Number of parameters being passed to the procedure. You must have one call to DBMS_DEFER.datatype_ARG for each parameter.
group_name	Optional. Reserved for internal use.
nodes	Optional. List of destination nodes (global_names) where the procedure is to be executed. If nodes are not specified, destinations are determined by the list passed to TRANSACTION.

Exceptions

Exception Name	Number	Description
malformedcall	–23304	Number of arguments in the call does not match value of arg_count.
ORA-23319	–23319	The parameter is NULL, misspelled, or not allowed.
ORA-23352	–23352	The nodes list contains a duplicate.

Restrictions

The procedures used in deferred RPCs must be part of a package; it is not possible to queue standalone procedures.