SELECT MAX(RE_DATE) INTO V_RE_DATE
FROM T_RECORDING
WHERE ID ='100010010102'

EXCEPTION
WHEN NO_DATA_FOUND THEN
NULL;
WHEN OTHERS THEN
ERR_CODE :=-2000;
ERR_MSG :=SQLERRM;
RETURN ;