Unmarking a Stored Procedure

When you unmark a stored procedure, 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.

To unmark stored procedures:

Log in to the Replication Agent instance with the administrator login.
Determine if replication is enabled for the stored procedure:
```
pdb_setrepproc pdb_proc
```
where pdb_proc is the name of the stored procedure that you want to unmark.
- If pdb_setrepproc returns information that the specified stored procedure is is marked, continue this procedure to unmark the stored procedure.
- If pdb_setrepproc returns information that the specified stored procedure is not marked, you do not need to continue this procedure.
Disable replication of the stored procedure:
```
pdb_setrepproc pdb_proc, disable
```

Unmark the stored procedure:

pdb_setrepproc pdb_proc, unmark

To force the unmark, use:

pdb_setrepproc pdb_proc, unmark, force

Confirm that the stored procedure is no longer marked for replication:
```
pdb_setrepproc pdb_proc
```

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

Note: If your stored procedure is in Oracle and you disabled DDL replication during stored procedure marking, remember to reenable DDL replication. Because marking a stored procedure modifies it, you must first disable DDL replication to prevent the marking modifications from replicating to the standby site.