Replication Agent 15.5 supports replication of stored procedures that include Boolean arguments, from Oracle to other databases.
Replication Agent sends the Boolean argument as an integer value to Replication Server, then Replication Server uses a function string to convert the integer value to Boolean. To execute the corresponding procedure at the replicate site, you need to manually create the function string to convert the integer value to Boolean in Replication Server, for each procedure that includes Boolean arguments. See the Replication Server 15.5 Reference Manual for information on how to create the function string.
Microsoft SQL Server does not support boolean as
a stored procedure argument. For this database, map the Boolean argument
at the primary site to an integer value at the replicate site. You
need not create a function string when replicating to these databases.
Products that support this feature include:
Oracle 10g or later
Replication Server 15.5
Replication Agent 15.5
See Chapter 1, “Replication Agent for Oracle,” in the Replication Agent 15.5 Primary Database Guide for details on how to replicate stored procedures with Boolean arguments from Oracle to other databases.
