Modify Source Code
Use this API to modify a Source Code definition or instance. You can modify the name and description. If you are modifying a Source Code instance, you can also change the 3 REF attribute values to select a different source definition.
Name
CDR_PUB_DF_SOURCECODE.ModifySourceCodeDetails
Signature
PROCEDURE MODIFYSOURCECODEDETAILS( 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, PIO_SCREF_SOURCECDRNAMING IN OUT CDR_NAMING_VERSION_OBJ_TYPE, PI_CDRSCOBJTYPE IN OUT CDR_SRCCODE_OBJ_TYPE, PIO_CDRSCREFOBJTYPE IN OUT CDR_SRCCODE_REF_OBJ_TYPE, PI_VLOBMODE IN VARCHAR2 := NULL, PIO_CDRSCBLOB IN OUT CDR_SRCCODE_BLOB_OBJ_TYPE, PIO_CDRSCCLOB IN OUT CDR_SRCCODE_CLOB_OBJ_TYPE );
Parameters
This API has standard parameters (see Standard Parameters) and the following parameters:
- PIO_SCREF_SOURCECDRNAMING (Mandatory) This is a parameter of table type
CDR_NAMING_VERSION_OBJ_TYPE. Enter values to identify the Source Code definition or
instance and enter new values for the attributes you want to modify.
You can change the name or description for either the definition or instance. For an instance you can also change to a different underlying source definition by entering values for the new definition in the three REF attributes.
Note:
Neither Source Code definitions nor instances can have a validation status or a version label. All attributes are required. - PI_CDRSCOBJTYPE (Mandatory) This is a parameter of table type
CDR_SRCCODE_OBJ_TYPE that contains object attributes specific to Source Code definitions.
If you are modifying a Source Code definition, enter values to identify the definition and enter new values for the attributes you want to modify.
You can modify SHAREABLE_FLAG_RC, ORACLE_PACKAGE_NAME, and ORACLE_PROCEDURE_NAME. All attributes are required.
- PIO_CDRSCREFOBJTYPE (Mandatory) This is a parameter of table type
CDR_SRCCODE_REF_OBJ_TYPE that contains object attributes specific to Source Code
instances.
If you are modifying a Source Code instance, enter values to identify the instance and enter new values for the attributes you want to modify. You can modify PRIMARY_FLAG_RC and FILEREF. All attributes are required.
- PI_VLOBMODE Enter 'DIRECT' if your source code is already contained in a BLOB
or CLOB file. You enter information about it in one of the next two parameters and the API
uploads it immediately.
If you enter anything other than 'DIRECT' the API creates a new, empty BLOB and CLOB in the next parameters. It prompts you to paste in your source code and then uploads the BLOB or CLOB.
- PIO_CDRSCBLOB This is a compound object of type CDR_SRCCODE_BLOB_OBJ_TYPE.
If the source code is binary, enter its name for the FILE_NAME attribute value and the BLOB itself for the FILE_BLOB attribute value.
- PIO_CDRSCCLOB This is a compound object of type CDR_SRCCODE_CLOB_OBJ_TYPE.
If the source code is text-based, enter its name for the FILE_NAME attribute value and the CLOB itself for the FILE_CLOB attribute value. Enter CLOB if the source code file is a character large object.
Parent topic: Create and Modify Source Code