ADD_OBJECT

Adds an object to a patch definition, including optional parameter for a where clause, objects may only be added while patch status is STARTED. possible objects are PSA tables and PSA Error tables If object is successfully added, the object status is set to ADDED.

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 (PSA or PSA-Error table)
p_where	no	optional where clause to query only necessary data from the object, if parameter is null all data will be prepared, not relevant when object is the ERR table

Example

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