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

Home -> Community -> Usenet -> comp.databases.theory -> Re: theory and practice: ying and yang

Re: theory and practice: ying and yang

From: Alfredo Novoa <alfredo_novoa_at_hotmail.com>
Date: Wed, 01 Jun 2005 16:05:48 +0200
Message-ID: <h4gr9193rtdsnotlfss05k035nmq7917up@4ax.com>


On Tue, 31 May 2005 12:10:27 -0400, Kenneth Downs <knode.wants.this_at_see.sigblock> wrote:

>> Declarative code should be favoured over procedural code.
>>
>> Stored procedures should be used as a last resort to implement
>> business rules.
>>
>
>But then you have the classic loophole problem. As soon as you allow that
>Sprocs are used for "last resort", you have to spell out the conditions
>under which they can be used and suddenly everyone is claiming they've got
>a special case and *must* use a sproc.

So what is the problem?

The last resort is also a resort.

>This is why you have to support them either entirely and systematically, or
>not at all, you can't have "last resort" case.

Stored procedures must be entirely supported, of course.

Regards Received on Wed Jun 01 2005 - 09:05:48 CDT

Original text of this message

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