April 1999
Intermediate to advanced
552 pages
15h 39m
English
Content preview from Oracle Distributed Systems
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.
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.
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access
More than 5,000 organizations count on O’Reilly
O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.Julian F.
I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.Addison B.
I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.Amir M.
I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.