I'll look into it...
But, if an exception was being raised...wouldn't oracle have spit out one of
those 'nasty' error messages? And, wouldn't the NVL take care of that?

Kelly

On Thu, Mar 28, 2002 at 03:01:13PM -0500, after pounding the keys randomly, [Email Address Removed] came up with....
>
> I suspect you have to put a exception handler for no_data_found exception.
>
> Rick
>
>
------------------

A computer lets you make more mistakes faster than any other invention,
With the possible exceptions of handguns and tequila.

------------------
Oracle LazyDBA home page