WHAT is the purpose of RAISE in an EXCEPTION clause ?
I have seen PL-SQL statements with EXCEPTION clause which contain a RAISE and other where the RAISE was omitted. E.g.
CREATE OR REPLACE FUNCTION my_func (...) RETURN ....
AS
retval .....
BEGIN
.....
RETURN retvaL;
EXCEPTION
WHEN NO_DATA_FOUND THEN
...
WHEN TOO_MANY_ROWS THEN
...
RAISE;
END;
/
What is the purpose of RAISE?