The message type enhancement can set up GoldenGate and switch ZDT schema processes. The ZDT schema process can switch from either the source environment or the target environment, though switching from the target environment is preferred.

Use the message type enhancement for the following use cases:

Update remote tables.

Run the following command to update remote tables:

Target C_REPOS_ZDT_STATUS.ACTIVE_UPGRADE_IND will set to 1 from source.
begin
cmxzdt.send_event_message(in_type=>cmxzdt.zdt_execute, in_parameters=>'update c_repos_zdt_status set active_upgrade_ind=1' ); 
end;
/

Call remote stored procedures.

Run the following command to generate extract processes and PRM files from the target environment:

begin
cmxzdt.send_event_message( in_type=>cmxzdt.zdt_execute, in_parameters=>'BEGIN CMXZDT.CONFIGURE_GGS_EXTRACT(CMXZDT.zdt_local); END;' );
end;
/

The message type enhancement cannot run any logic that uses messages recursively.