CREATE OR REPLACE PROCEDURE CR_ARCHIVE_REGISTRY.COMPARE_TABLES(cur_tables IN VARCHAR2, l_batch_no IN NUMBER) AS l_prod_schema VARCHAR2(30) := 'CR_5_0_X'; l_arch_schema VARCHAR2(30) := 'CR_ARCHIVE'; l_error_message VARCHAR2(3000); -- Va