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 ofexecplsql
. This function or procedure will be executed by theexecplsql
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.