BEGIN
FUNCTION coyname(sql_id IN planchangetbl.sql_id%TYPE)
RETURN VARCHAR2
IS
echange planchangetbl.sql_id%TYPE;
BEGIN
select distinct s.sql_id, s.plan_hash_value, b.begin_interval_time, b.end_interval_time,
s.min_snap_id, s.max_snap_id INTO echange from sys.hashchange s, sys.planchangetbl b
where s.sql_id = b.sql_id
and b.snap_id BETWEEN s.min_snap_id AND s.max_snap_id
RETURN echange;
EXCEPTION
WHEN NO_DATA_FOUND
THEN
RETURN NULL;
END;
END;