Re: PL/SQL : Alternative way of doing if any

From: Frank van Bortel <frank.van.bortel_at_gmail.com>
Date: Fri, 19 Aug 2005 14:12:08 +0200
Message-ID: <de4hte$f5b$2@news2.zwoll1.ov.home.nl>

Billy wrote:
> Noel wrote:
>
>

>>Baka's code will raise exception when, from some reason, cursor fail to
>>open. No mysterious runtime errors occurs, there will be %NOTFOUND
>>pseudocolumn of cursor set to TRUE if cursor fetches no records.

>
>
> Bull! DBMS_OUTPUT does not have an infinite buffer size.

It does, in 10g - the OP did not reveal his version, though.

What happens
> when the buffer gets full? And there is no ways that 4 lines of code
> for an getting a result into a variable is more sensible in this case
> than a single line.
>
>

>>Your example might raise three kind of exception, no_data_found,
>>too_many_rows and other exception, and you'll need to put some code for
>>all of those.

>
>
> Exactly. You do want the exceptions. You do want unhandled exceptions
> to be passed up the calling stack.

Agreed

>
> Do you actually know what exception handling is all about and what the
> differences are between dealing with exceptions via handlers and
> dealing with runtime errors using in-line IF block coding?
>
>

>>I would stick by Baka's solution.

>
>
> Solution!? That explains your comments. I honestly don't have the time
> or inclination to explain to you the very basics of programming. I
> suggest that you get yourself booked on a course that explains
> programming fundementals.
>
> --
> Billy
>

-- 
Regards,
Frank van Bortel

Top-posting is one way to shut me up...

Received on Fri Aug 19 2005 - 07:12:08 CDT