Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: PL/SQL coding style

RE: PL/SQL coding style

From: Chandini Paterson <chandini.paterson_at_morse.com>
Date: Thu, 18 Jan 2001 17:18:06 -0000
Message-Id: <10745.127024@fatcity.com>


He's been with the company longer than me obviously and because he was the only person who could allegedly program (before I entered the picture), he is considered something short of a genius!!! No matter what I tell the guy, he just refuses to see sense. Oh well, maybe I should do as you say and hit him on the head ;-)

-----Original Message-----

From: root_at_fatcity.com [mailto:root_at_fatcity.com]On Behalf Of Brian_McQuillan_at_gelco.com
Sent: 18 January 2001 16:51
To: Multiple recipients of list ORACLE-L Subject: 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)

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).

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author:
  INET: Brian_McQuillan_at_gelco.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 Received on Thu Jan 18 2001 - 11:18:06 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US