MODIFY_OBJECTΒΆ

Modifies an object of a patch definition, only the WHERE clause can be modified and the modification con only be done before the patch is prepared.

Parameter Name

Required

Description

p_patch_id

yes

Id of the patch

p_obj_schema

yes

schema of the object to be patched

p_obj_table

yes

name of the object to be patched

p_where

no

optional where clause to query only necessary data from the object, if parameter is null all data will be prepared

Example

EXECUTE SCRIPT api_redpat.modify_object
            ( 'XXX'      -- p_patch_id
            , 'XXX'      -- p_obj_schema
            , 'XXX'      -- p_obj_table
            , 'XXX'      -- p_where
            )