RPASCE Special Expression - execplsql

The special expression execplsql provides the ability to invoke the customer uploaded PL/SQL functions and procedures from within the RPASCE rules and expressions framework. Both functions and procedures are supported. Also execplsql is variadic and can take an arbitrary number of arguments that can be of different types according to the PL/SQL signature. The number and type depend on the signature of the function or procedures being executed. The first two arguments to execplsql are reserved to indicate the package name and the function or procedure name to be executed.

Example

drdvsrcti<-execplsql("RP_CUSTOM_PKG","sum",drdvsrctt, adhdlcratet, add2locopnd)

In this example the LHS measure drdvsrcti is a scalar integer measure. It will be set to the integer value returned by the function named sum in the customer uploaded package RP_CUSTOM_PKG.