PL/SQL ITEMS

The PL/SQL plugin allows stored procedures to be called

• name. The name of this item.

• call. The name of the stored procedure.

• sub. The subroutine being called.

• parameters. Name/Value pairs.

• on_error. Override the setting for the job.

Example

    <item>
        name     = record_file
        call     = record_file
        type     = plsql
        on_error = die
        <parameters>
                name = filename
                value = %basename(filename)%
        </parameters>
        <parameters>
                name = message
                value = %message%
        </parameters>
        <parameters>
                name = archive_dir
                value = %archive_dir%
        </parameters>
    </item>

1. Only iterative jobs can use iterative placeholders like %filename%.

2. If the item parameter value is %message%, the plugin requires that the PL/SQL parameter is an IN/OUT type. The message will be logged in the runtime audit history. This provides a mechanism to pass messages back to ETLp from the PL/SQL code.