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.