PL/SQL problem 1

[roy29]

I have a Procedure with an SQL statement in it that selects rows back from a table into variables. If the statement doesn't return any rows then an exception is raised. I'd like to handle the exception by just letting the procedure terminate gracefully.

Thanks for any help in advance.

 

[lewisp]

Your exception whould be

[tt]
EXCEPTION
WHEN NO_DATA_FOUND
THEN
Null;
END;[/tt]