Oracle stored procedures as event handlers

There are several parameter that are invoked with the stored procedure if you have configured and event handler as am Oracle stored procedure.

If you configure an event handler as an Oracle stored procedure, the stored procedure is invoked with the following parameters:

PROCEDURE DO_ACTION(TRANID IN VARCHAR2,ACTIONCODE IN VARCHAR2,KEY_DATA IN 
VARCHAR2,DATA_TYPE IN NUMBER,DATA_BUFFER1 IN VARCHAR2,DATA_BUFFER2 IN 
VARCHAR2,DATA_BUFFER3 IN VARCHAR2,DATA_BUFFER4 IN VARCHAR2,DATA_BUFFER5 IN 
VARCHAR2,DATA_COMPLETE IN NUMBER,SHIP_NODE IN VARCHAR2,RETURN_VALUE IN OUT NUMBER)

PL/SQL limits the maximum size of a VARCHAR2 variable to 2,000 bytes, so 2,000 bytes is the maximum length of the string passed in data buffers. If the input is greater than 10,000 characters, the buffer is truncated and the parameter DATA_COMPLETE has a value of 0 (zero). If the buffer is less than 10,000 bytes and is completely passed to the stored procedure, DATA_COMPLETE is passed as 1.

Important: You must not do a commit or a rollback in the stored procedure at any time in a stored procedure associated to a event handler.

Execution of stored procedures is not a supported service component.