This illustration shows an apply process dequeuing LCRs and messages from the queue and either applying LCRs directly or passing messages to an apply handler. The apply handlers include a message handler procedure to process user messages, a DML handler procedure to process row LCRs, a DDL handler procedure to process DDL LCRs, and a precommit handler to record commit information for LCRs or user messages.
Specifying DDL, Message, and Precommit Handler Procedures
DDL、メッセージおよびプリコミット・ハンドラのプロシージャの指定
A collection of SQL statements or a user-defined procedure used by an apply process for customized processing of messages. Apply handlers include statement DML handlers, message handlers, procedure DML handlers, DDL handlers, precommit handlers, and error handlers.
Using the General subtab, you can set the DDL handler, message handler, and precommit handler for the apply process. To set a handler, specify the handler procedure name either by searching for the procedure or entering it manually. To remove a handler, click the Remove button associated with the handler.
You can use apply handlers to handle messages dequeued by an apply process in a customized way. These handlers include DML handlers, DDL handlers, precommit handlers, and message handlers. If an apply process is not behaving as expected, then check the handler procedures used by the apply process, and correct any flaws. You might need to modify a handler procedure or remove it to correct an apply problem.
A persistent user message is processed by the message handler specified for an apply process. A message handler is a user-defined procedure that can process user messages in a customized way for your environment.
If a conflict is not resolved, or if a handler procedure raises an error, then all messages in the transaction that raised the error are saved in the error queue for later analysis and possible reexecution.
An apply process is an Oracle background process that dequeues messages from a queue and either applies each message directly to a database object or passes the message as a parameter to a user-defined procedure called an apply handler. Apply handlers include message handlers, DML handlers, DDL handler, precommit handlers, and error handlers.
You can use a precommit handler to audit commit directives for captured messages and transaction boundaries for user-enqueued messages. A precommit handler is a user-defined PL/SQL procedure that can receive the commit information for a transaction and process the commit information in any customized way. A precommit handler can work with a DML handler or a message handler.
With implicit consumption, an apply process automatically dequeues either captured LCRs, persistent LCRs, or persistent user messages. The queue must be an ANYDATA queue. If a message contains a logical change record (LCR), then the apply process can either apply it directly or call a user-specified procedure for processing. If the message does not contain an LCR, then the apply process can invoke a user-specified procedure called a message handler to process it.
The message handler class is listed in the dialog box.
メッセージハンドラクラスがダイアログに表示されます。
The inbound request packets are routed to the appropriate message handler.
着信要求パケットが適切なメッセージ・ハンドラに送られます。
Conținut posibil inadecvat
Exemplele au rolul de a te ajuta să traduci cuvinte sau expresii corect si adaptat la context. Nu sunt selectate sau validate manual, așadar pot conține termeni inadecvați. Te rugăm să raportezi exemplele pe care le consideri inadecvate. Traducerile vulgare sau colocviale sunt în general marcate cu roșu sau cu portocaliu.