| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> 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
>be greatly appreciated.
>
>Thanks
>Chandini
>
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: Chandini Paterson
> INET: chandini.paterson_at_morse.com
>
>Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
>San Diego, California -- Public Internet access / Mailing Lists
>--------------------------------------------------------------------
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(or the name of mailing list you want to be removed from). You may
>also send the HELP command for other information (like subscribing).
 |
 |