Unmarking a stored procedure

When you unmark a stored procedure, Mirror Replication Agent removes the transaction log objects that were created when the stored procedure was marked.

For Oracle, DDL replication must be disabled during the unmarking of stored procedures. See “Disabling replication for DDL”.

Log in to the Mirror Replication Agent instance with the administrator login.
Use the pdb_setrepproc command to confirm that the stored procedure is marked in the primary database:
```
pdb_setrepproc pdb_proc
```
Here, pdb_proc is the name of the stored procedure that you want to unmark.
- If the pdb_setrepproc command returns information that the specified stored procedure is marked, continue this procedure to unmark the stored procedure.
- If the pdb_setrepproc command does not return information that the specified stored procedure is marked, you do not need to continue this procedure.
Use the pdb_setrepproc command to disable replication of the stored procedure:
```
pdb_setrepproc pdb_proc, disable
```
Here, pdb_proc is the name of the stored procedure that you want to unmark.
Use the pdb_setrepproc command to remove the replication marking from the stored procedure:
```
pdb_setrepproc pdb_proc, unmark
```
Here, pdb_proc is the name of the stored procedure that you want to unmark.

If you need to force the unmark, you can use the following command:
```
pdb_setrepproc pdb_proc, unmark, force
```
Use the pdb_setrepproc command to confirm that the stored procedure is no longer marked for replication:
```
pdb_setrepproc pdb_proc
```
Here, pdb_proc is the name of the stored procedure in the primary database that you unmarked.

You can unmark all marked stored procedures in the primary database by invoking the pdb_setrepproc command with the all keyword.

If your stored procedure is in Oracle and you disabled DDL replication during stored procedure unmarking, remember to re-enable DDL replication. See “Enabling replication for DDL”.