Arguments

LHS

The LHS measure must be a scalar integer measure. It will be set to the integer value returned by the customer-uploaded PL/SQL function or procedure. The integer value is meant to be a return code indicating the result of the procedure or function execution. In case of exceptions, RPASCE will set the LHS measure to a value of -1 to indicate an error. If there are any exceptions or failures, then the logs will provide further information regarding the reason for the failure.

RHS

• First argument:

  The type of the first argument is string. It can either be a string constant or a scalar string measure. The first argument is the name of the customer-uploaded package. For more details regarding uploading custom packages refer to section Uploading Custom PL/SQL Packages.

• Second Argument:

  The type of the first argument is string. It can either be a string constant or a scalar string measure. The second argument is the name of a function or procedure within in the custom package specified as the first argument of execplsql. This function or procedure will be executed by the execplsql special expression when it is evaluated.

  If a function is being specified, make sure the return type is declared as a number in the PL/SQL function declaration.

  If a procedure is being specified, make sure there is exactly 1 out type parameter of type number in the PL/SQL procedure declaration.