Tratar com 0 return nulo

BEGIN
SELECT NVL(reversesmsaccnr,0)
INTO X_SMS_REVERTE
FROM smsacc
WHERE smsaccnrbrnr = X_SMS_ATUAL;
END;