CREATE OR REPLACE FUNCTION GET_UUID (v_id in RAW)
RETURN VARCHAR
IS
guid VARCHAR (50);
BEGIN
guid := rawtohex(v_id);
RETURN
lower(substr(guid,1,8)||'-'||substr(guid,9,4)||'-'||substr(guid,13,4)||'-'||substr(guid,17,4)||'-'||substr(guid,21,12));
END GET_UUID;