Select Code to Download

CREATE OR REPLACE FUNCTION sitescope.get_id_servername ( v_value sites
+copelog.servername%TYPE ) RETURN archive_servername.id%TYPE AS
        PRAGMA  AUTONOMOUS_TRANSACTION;
        v_id    archive_servername.id%TYPE;
...
            RETURN (v_id);
    END;
/

CREATE OR REPLACE PROCEDURE sitescope.archive_from_sitescopelog AS
        CURSOR sitescopelog_cursor IS
            SELECT --+ INDEX(sitescopelog arc_idx_datex)
...
        END IF;
    END;
/