List:General Discussion« Previous MessageNext Message »
From:Ed Carp Date:September 7 2001 4:03pm
Subject:RE: Let's approach stored procedures
View as plain text  
> - it's cool

Not a valid business reason.

> - where I work, we have a HUGE database-driven web-application. A lot of
>    our business logic is implemented via stored procedures, that
>    act as black boxes for the web-designers.
>    Think of enterprise java beans.
>    They are not "nonsense" or such. They are usefull.

Stored procedures aren't nonsense, but using or re-implementing a particular
vendor's implementation is.

>    (I know, you can use ejb with JDBS and mysql..., but if you
> want to have
>    some logic incapsualted, you should use some kind of "component")
> - sp extends the RDBMS itself in its functionality. Think about
> some stupid
>    "check_fiscal_code()" or "insert_new_customer()".
>    Web designers use the "insert_new_customer", instead of using SQL
>    directly.

These are all great reasons to implement stored procedures, not Oracle
PL/SQL. I think I'm missing your point here...
--
Ed Carp, N7EKG  -  erc@stripped  -  214/341-4420 -
http://www.pobox.com/~erc

Squished Mosquito, Inc.
Internet Applications Development
Escapade Server-Side Scripting Language Development Team
http://www.squishedmosquito.com
Pensacola - Dallas - Dresden - London

Thread
Let's approach stored proceduresClaudio Cicali7 Sep
  • Re: Let's approach stored proceduresBill TQO Adams7 Sep
  • Re: Let's approach stored proceduresCal Evans7 Sep
Re: Let's approach stored proceduresEd Carp7 Sep
  • Re: Let's approach stored proceduresClaudio Cicali7 Sep
    • RE: Let's approach stored proceduresEd Carp7 Sep
      • RE: Let's approach stored proceduresClaudio Cicali7 Sep
    • Re: Let's approach stored proceduresDana Powers7 Sep
  • Re: Let's approach stored proceduresCal Evans7 Sep
    • Re: Let's approach stored proceduresWilliam R. Mussatto7 Sep
      • Re: Let's approach stored proceduresCal Evans7 Sep
      • RE: Let's approach stored proceduresEd Carp7 Sep
        • RE: Let's approach stored proceduresRobert Alexander7 Sep
          • Re: Let's approach stored proceduresEndre Stølsvik10 Sep
            • Re: Let's approach stored proceduresArnulf Kristiansen11 Sep
              • Re: Let's approach stored proceduresClaudio Cicali11 Sep
              • Re: Let's approach stored proceduresEndre Stølsvik13 Sep
                • Re: Let's approach stored proceduresJames Clifford13 Sep
                • Re: Let's approach stored proceduresArnulf Kristiansen13 Sep
                • Re: Let's approach stored proceduresArnulf Kristiansen13 Sep
            • Re: Let's approach stored proceduresJeremy Zawodny11 Sep
  • Re: Let's approach stored proceduresBill TQO Adams7 Sep
  • Re: Let's approach stored proceduresFrank Fisher10 Sep
  • Re: Let's approach stored proceduresDana Powers10 Sep
Re: Let's approach stored proceduresEd Carp7 Sep
  • Re: Let's approach stored proceduresCal Evans7 Sep