Oracle equivalent of ABORT where in teradata

Question

In teradata you can do something like this:

ABORT    'custome message'
WHERE    :parameter_var NOT IN
(
SELECT
var
FROM    table_name
);
exec delete_something(:parameter_var);

What's the equivalent in Oracle. I'm thinking of using exceptions but not sure what the best approach is. Thanks in advance!

Answer 1

    SELECT var into v_dummy from table_name;
    exec delete_something(:parameter_var);

EXCEPTION
    WHEN NO_DATA_FOUND THEN
    RAISE_APPLICATION_ERROR(-20000,'customer message');