Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: PL/SQL coding style
Chandini,
The use of the goto's alone justifies hitting him over the head repeatedly with
some nice book like Oracle 8i PL/SQL programming
goto is bad news in any language (never mind c) as it leads to very unstructured
programming and bad things tend to happen.
my $0.02 worth
so.... that being the case why is he the Senior Developer ?
Brian.
"Chandini Paterson" <chandini.paterson_at_morse.com> on 01/18/2001 11:01:57 AM
Please respond to ORACLE-L_at_fatcity.com
To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> cc: (bcc: Brian McQuillan/GELCO)
Subject: PL/SQL coding style
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-LReceived on Thu Jan 18 2001 - 11:01:58 CST
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
![]() |
![]() |