Known Issues for Replication Agent

Learn about known issues and apply workarounds for Replication Agent.

Replication Agent Issues

CR#

Description

596321, 596320 Replication Server does not support specifying owner information of stored procedures in the function replication definition for Oracle.

Therefore, Replication Agent cannot send that information to Replication Server. Because the owner information is not available, the replicated stored procedure fails to execute at the Oracle standby database.

Workaround: For each stored procedure that is replicated from an active to a standby database, create a corresponding function string. Specify owner information in the target stored procedure.

To customize the function-string class of the standby connection, which is inherited from rs_oracle_function_class, enter:

alter connection to dco2stb.ordb (standby connection)
set function string class to my_oracle_function_class 
go