Set an Output Parameter
Use this API to send custom parameters and their values to Oracle LSH from external sources such as SAS. Parameter names and their values passed to this API get added to the cdr_temp_output_params table.
Name
CDR_PUB_EXE_USER_UTILS.SetOutputParams
Signature
PROCEDURE SETOUTPUTPARAMS( P_API_VERSION IN NUMBER, P_INIT_MSG_LIST IN VARCHAR2 := CDR_PUB_DEF_CONSTANTS.G_FALSE, P_COMMIT IN VARCHAR2 := CDR_PUB_DEF_CONSTANTS.G_FALSE, P_VALIDATION_LEVEL IN NUMBER := CDR_PUB_DEF_CONSTANTS.G_VALID_LEVEL_FULL, X_RETURN_STATUS OUT VARCHAR2, X_MSG_COUNT OUT NUMBER, X_MSG_DATA OUT VARCHAR2, PI_VPARAMNAME IN CDR_TEMP_OUTPUT_PARAMS.PARAMETER_NAME%TYPE, PI_VPARAMVALUE IN CDR_TEMP_OUTPUT_PARAMS.PARAMETER_VALUE%TYPE );
Parameters
This API has standard parameters (see Standard Parameters) and the following parameters:
- PI_VPARAMNAME (Mandatory) Enter the parameter name.
- PI_VPARAMVALUE (Mandatory) Enter a value for the parameter.
Parent topic: Set Execution Statuses