exceptions & performance

From: <kal121_at_my-deja.com>
Date: 2000/05/15
Message-ID: <8fpg4j$pjb$1@nnrp1.deja.com>#1/1

Is there any reason *not to* use an exception handler as a means of execution control in Oracle?

Basically, I have a very simple procedure that does a SELECT. If and when the data is not found, I simply catch the exeception DATA_NOT_FOUND, then terminate the procedure.

I was told by a java developer that catching exceptions is always expensive. Is this also true in Oracle?

I can always declare an explicit cursor to check for %FOUND - is this a better way to accomplish this than using an exception handler? I suppose I can test this against a large data set, but the one I have isn't big enough at the moment. Any experiences?

Thanx

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Mon May 15 2000 - 00:00:00 CDT