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.
Get Oracle Distributed Systems now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.