376: /* Convert the sysdate to a string so we can concatenate it into the
377: snapshot object name */
378: SELECT to_char(sysdate, 'YYYY/MM/DD HH24:MI:SS')
379: INTO v_sysdate 380: FROM dual; 381:
382:
383: /* Verify the mapping rule is valid and get mapping rule object info
384: NOTE: object_name for the snapshot will be = true rule object_id, because