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

Home -> Community -> Usenet -> c.d.o.server -> Re: choices regarding where to place code - in the database or middletier

Re: choices regarding where to place code - in the database or middletier

From: Daniel Morgan <damorgan_at_x.washington.edu>
Date: Thu, 29 Jan 2004 21:57:10 -0800
Message-ID: <1075442171.779310@yasure>


Stu Charlton wrote:

>>So while I will gladly acknowledge a communication gap I still can't get 
>>past thinking what you guys are proposing is a logical impossibility. If 
>>you disagree, and I suspect you do/will, then please provide an example 
>>of how you could use packages and sequences in Oracle and meet your 
>>stated objective.

>
>
> Ok.
>
> Requirement: A web-page that displays all of the employees in a given
> department.

> Cheers
> Stu

First let me say you have my admiration. You put in effort and made an attempt at answering my query. But the problem is that your example very carefully, perhpas even artfully, dodged the issue I put in front of you like a charging rhinoceros. What I asked was "please provide an example of how you could use PACKAGES and SEQUENCES in Oracle and meet your stated objective" ... and you didn't.

By selecting as your example: "A web-page that displays" you eliminated anything having to do with sequences. What I was trying to get you to deal with was issues related to insert, update, and delete. Issues that involve sequences but also the transaction and locking models that are totally different between commercial database products.

So the response while impressive is unsatisfactory in that it didn't address the issue. And the stuff about Project Marvel ... as marvelous as it may be ... has nothing to do with the back-end database ... HTML_DB is a front-end tool. Could I impose upon you to try again this time addressing this issues around transaction processing.

I still content that you can't have your cake and eat it too.

Thanks.

-- 
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)
Received on Thu Jan 29 2004 - 23:57:10 CST

Original text of this message

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