Upload an Output CLOB
Use this API to upload an output CLOB into Oracle LSH.
Name
CDR_PUB_EXE_EXTERNAL.UploadClobOutput
Signature
PROCEDURE UPLOADCLOBOUTPUT( 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_NJOBID IN VARCHAR2, PI_VFILENAME IN VARCHAR2, PI_NPRREFID IN VARCHAR2, PIO_CLOBSTREAM IN OUT CLOB );
Parameters
This API has standard parameters (see Standard Parameters) and the following parameters:
- PI_NJOBID (Mandatory) Enter the JOB_ID of the job that generated the output.
- PI_VFILENAME (Mandatory) Enter the filename associated with the Planned Output.
- PI_NPRREFID (Mandatory) Enter the PRREFID of the Oracle LSH executable. This attribute is available from the CDR_JOBS table.
- PIO_CLOBSTREAM (Mandatory) Enter the variable name for the CLOB in the database.
Parent topic: Create and Execute Output LOBs