Learn how to replicate Oracle stored procedures with arguments of boolean type.
To replicate an Oracle stored procedure with an argument of type BOOLEAN, Replication Agent sends the BOOLEAN argument to Replication Server as an integer. Replication Server then uses a function string to convert the argument back to a BOOLEAN value so that the stored procedure can be executed on the replicate database. On Replication Server, you must manually create this function string for each Oracle stored procedure that has an argument of type BOOLEAN.
Some replicate databases do not support BOOLEAN stored procedure arguments. In these cases, the Oracle stored procedure BOOLEAN argument should be mapped to an integer argument in the corresponding stored procedure at the replicate database. A function string is then unnecessary.
These examples illustrate how to replicate an Oracle stored procedure with an argument of type BOOLEAN to a Oracle replicate database and to a non-Oracle replicate database.