NO DATA FOUND error

Trap the NO_DATA_FOUND exception, and handle it.

BEGIN 
    SELECT ... INTO   x_data
    FROM   ...
    WHERE  ...;
EXCEPTION
    WHEN NO_DATA_FOUND THEN
        x_data := NULL;
END;