Mark stored procedures for replication.
Before you can stored procedures for replication, you must create the Replication Agent transaction log objects.
For Oracle, DDL replication must be disabled during the marking of stored procedures. Because marking of a stored procedure modifies that stored procedure, you must first disable DDL replication to prevent the marking modifications from replicating to the replicate site.
pdb_setrepproc pdb_proc
where pdb_proc is the name of the stored procedure that you want to mark for replication.
When the procedure in the replicate database has the same name as the procedure in the primary database, use:
pdb_setrepproc pdb_proc, mark
When the procedure in the replicate database has a different name from the procedure in the primary database, use:
pdb_setrepproc pdb_proc, rep_proc, mark
where rep_proc is the name of the procedure in the replicate database.
pdb_setrepproc pdb_proc, mark
If the procedure in the replicate database has the same name as the function replication definition, there is no need to use the deliver as clause. For example,
create function replication definition pdb_proc with primary at data_server.database ...
If the procedure in the replicate database has a different name from the name of the function replication definition, the function replication definition must map to the procedure in the replicate database. For example,
create function replication definition pdb_proc with primary at data_server.database deliver as ‘rep_proc’ ...
pdb_setrepproc pdb_proc, rdpri_proc, mark
where rdpri_proc is the name of the function replication definition. The function replication definition must map to the procedure in the replicate database.
If the procedure in the replicate database has the same name as the function replication definition, there is no need to use the deliver as clause. For example,
create function replication definition rdpri_proc with primary at data_server.database ...
If the procedure in the replicate database has a different name from the function replication definition, the function replication definition must map to the procedure in the replicate database. For example,
create function replication definition rdpri_proc with primary at data_server.database deliver as ‘rep_proc’ ...
pdb_setrepproc pdb_proc, enable
After replication is enabled for the stored procedure, you can begin replicating invocations of that stored procedure in the primary database.