Oracle 10g error : “O/S Message: No such file or directory”

This one was a pain in the ass. It seems like pre-Oracle 10g SQL will not always run on 10g. The construct in question is :

whenever oserror exit failure

In 10g, this will fail with the error message :

O/S Message: No such file or directory

Thanks to the Annals of Oracle’s Improbable Errors website for helping out with this. The solution in my case was to comment it out, but it might not always be so easy.