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.
You can unmark all marked stored procedures in the primary database by invoking pdb_setrepproc with the all keyword.