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
)