Get a Source Code CLOB

Use this API to get the source code CLOB.

Name

CDR_PUB_DF_SOURCECODE.GetSourceCode

Signature

FUNCTION GETSOURCECODE( 
  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, 
  COMPANYID  IN    CDR_NAMINGS.COMPANY_ID%TYPE, 
  OBJID  IN    CDR_NAMINGS.OBJ_ID%TYPE, 
  OBJVER  IN    CDR_NAMING_VERSIONS.OBJ_VER%TYPE, 
  NSOBJID  IN    CDR_NAMINGS.OBJ_ID%TYPE, 
  NSOBJVER  IN    CDR_NAMING_VERSIONS.OBJ_VER%TYPE 
) RETURN CLOB; 

Return

Type CLOB

Parameters

This API has standard parameters (see Standard Parameters) and the following parameters:

  • COMPANYID (Mandatory) Enter your company ID.
  • OBJID (Mandatory) Enter the object ID of the Source Code definition.
  • OBJVER (Mandatory) Enter the object version (OBJ_VER) of the Source Code definition.
  • NSOBJID (Mandatory) Enter the object ID of the Program definition that contains the Source Code definition.
  • NSOBJVER (Mandatory) Enter the object version (OBJ_VER) of the Program definition that contains the Source Code definition.