RE: PL/SQL coding style

Speaking of style, Rachel humbly did not mention her book because she has style. But since I have none it's "Oracle SQL & PL/SQL Annotated Archives" from Oracle Press. Oh yeah, it's co-author by some guy named Kevin something. :-)

ever so gauche,
Steve Orr

-----Original Message-----
From: root_at_fatcity.com [mailto:root_at_fatcity.com]On Behalf Of Rachel Carmichael
Sent: Thursday, January 18, 2001 11:29 AM To: Multiple recipients of list ORACLE-L Subject: Re: PL/SQL coding style

Doesn't sound like C style to me... that sort of coding style (the gotos) goes back to when I first started programming in Cobol and Fortran (yes, my age is showing)

As for the select into.. double fetch is, or can be, a big deal.

If your code works, he should not be imposing his style on you.

My $.02

>From: "Chandini Paterson" <chandini.paterson_at_morse.com>
>Reply-To: ORACLE-L_at_fatcity.com
>To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
>Subject: PL/SQL coding style
>Date: Thu, 18 Jan 2001 08:01:58 -0800
>
>Hi gurus,
> I've just changed jobs quite recently and am already having problems
>with
>my Senior Developer (yippee)
> It concerns the PL/SQL coding style. The guy insists that I use 'SELECT
>..INTO ' in my code rather than explicit cursors, even though I tried
>telling him it is more efficient with the latter. He apparently finds it
>more 'readable' with the 'SELECT.. INTO ' and says that the double fetch
>(for each row) is 'no big deal'.
> Also, he insists of using a lot of GOTOs in his code and expects me to
>do
>the same. I am adamant that we use EXCEPTION handlers to achieve the same
>thing (BAsically he checks for error conditions in his code and then does a
>'goto error_handler' to handle the error!!!). I prefer using EXCEPTIONS to
>handle all my error conditions.
> I was just wondering if my concepts are all wrong at this time. I am
>just
>curious to know if any of you find his way of coding style preferable to
>mine. (OH, by the way, he was initially a 'C' progrmmer). Any inputs will
Received on Thu Jan 18 2001 - 16:35:07 CST