Re: Oracle stored procedures vs Running from a flat .sql file

From: Karsten Farrell <kfarrell_at_belgariad.com>
Date: Wed, 08 Jan 2003 22:58:38 GMT
Message-ID: <y22T9.1088$vF1.65109170@newssvr21.news.prodigy.com>

Martin Doherty wrote:
> Alex Filonov wrote:
>

>> However, in most cases you need to modify stored objects in order to
>> debug.
>>

> That's often because the people who code the stored procedures generally
> do not prepare well for the inevitable debugging phase.
>
> Martin Doherty
>

How very true that is!

I remember back in the early 1960s wishing some Fortran programmer had added a few debugging print() statements in their mega-line program ... or maybe just a smattering of comments to let me know what's going on.

I remember back in the early 1970s wishing some Cobol programmer had added a few debugging display statements in their mega-line program ... or maybe just a smattering of comments to let me know what's going on.

I remember back in ... well you get my drift. Now it's a new century and we've got stored procedures ... but the original developers still code as if there'll never be a change made to their wonderful work of art.

Maybe that's why developers always want to work on the latest technology ... that way they don't have to face the problems that production (maintenance) developers face trying to patch up their unreadable code. Fortunately for my sanity, I'm out of that side of the business. :) Received on Wed Jan 08 2003 - 16:58:38 CST