Can a single 'when' clause handle multiple exception types in oracle?

Yes you can.

You can use OR conditions between the exceptions so

EXCEPTION  WHEN an_exception     OR another_exception  THEN    handle it here;END;

See The Docs for more details on exception handling.

CodeHunter