Examples with "general procedure dml handler" and their translation in Japans
We konden deze vermelding niet vinden. Er worden benaderende resultaten weergegeven. Controleer je spelling of stel voor deze term aan het woordenboek toe te voegen.
This topic describes setting a general procedure DML handler or error handler. A general handler is used when any apply process dequeues a row logical change record (row LCR) that contains the specified operation and the specified table.
Select the procedure DML handler or error handler that you want to edit.
編集するプロシージャDMLハンドラまたはエラー・ハンドラを選択します。
Managing Procedure DML Handlers and Error Handlers
プロシージャDMLハンドラおよびエラー・ハンドラの管理
You can also use SQL generation in a procedure DML handler to record the DML changes made to a table. You can record these changes in a table or in a file.
An error handler cannot co-exist with a procedure DML handler for the same operation on the same table. However, an error handler can co-exist with a statement DML handler for the same operation on the same table.
An error handler is similar to a procedure DML handler. The difference between the two is that an error handler is invoked only if an apply error results when an apply process tries to apply a row LCR for the specified operation on the specified table.
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.
To create a procedure DML handler or error handler, create a PL/SQL procedure that performs customized processing of row logical change records (LCRs).
A procedure DML handler should never commit and never roll back, except to a named savepoint that the user-defined PL/SQL procedure has established. To execute a row LCR inside a procedure DML handler, invoke the EXECUTE member procedure for the row LCR. Also, a procedure DML handler should handle any errors that might occur during processing.
A procedure DML handler can be used for any customized processing of row LCRs. For example, the handler can modify an LCR and then execute it using the EXECUTE member procedure for the LCR. When you execute a row LCR in a procedure DML handler, the apply process applies the LCR without calling the procedure DML handler again.
You can add set both a statement DML handler and a procedure DML handler for the same operation on the same table. When both are set, an apply process passes a row LCR to both the statement DML handler and the procedure DML handler. The DML handlers can be run in any order, and each DML handler receives the original row LCR.
Use this page to create new or edit existing SQL statements to be used as statement DML handlers. These handlers can process row LCRs in a customized way using a collection of SQL statements. Statement DML handlers typically perform better than procedure DML handlers because statement DML handlers require no PL/SQL processing.
Er worden alleen voorbeelden gegeven om u te helpen het woord of de woordcombinatie waarop u hebt gezocht, te vertalen. Deze worden niet door ons geselecteerd of gevalideerd en kunnen ongepaste taal bevatten. Wij vragen u melding te maken van voorbeelden die dienen te worden aangepast of verwijderd. Vertalingen met grof of informeel taalgebruik worden meestal rood of oranje gemarkeerd.