Oracle FAQ Your Portal to the Oracle Knowledge Grid

Home -> Community -> Usenet -> comp.databases.theory -> Re: pros and cons of using stored procedures

Re: pros and cons of using stored procedures

From: Dave <>
Date: Sat, 8 Sep 2001 19:34:49 -0400
Message-ID: <9ne9v3$csn$>

About the only con I have run into over the years is that Stored procedures tend to tie your app to a single database engine. Which is relatively minor as they are usually not that hard to prot to another one if needed.

"Roberto Padovani" <> wrote in message
> On 07 Sep 2001 15:47:56 -0700, Rusty Wright
> <rusty_at_socrates.Berkeley.EDU> wrote:
> >Can anyone recommend a book, web page, etc. that explains the pros and
> >cons of using stored procedures, as opposed to putting the code in
> >your front-end code? The background info is that a group of us are
> >designing a database and we'll be using Oracle, and for the front-end
> >we'll be using a web interface probably with the PHP scripting
> >language as the glue.
> >
> >One of the people on the team is a proponent of using stored
> >procedures and another is against it. Obviously, none of us are
> >database experts and I'd like to be able to read up on stored
> >procedures so that we can argue the issue intelligently.
> >
> >Thanks
> whenever i look for that kind of info i start from
> i've found links for almost everything i ever needed for my db related
> questions. That's NOT my site, i'm not advertising, and i don't know
> Pal directly... i just found there a lot of links to interesting
> resources and, most of all, Pal has been very kind answering to my
> email.
> personally, as we're also working on a project based on the three db
> (interbase) - php - web, i've also come into the same question: SPs or
> not? I took care of the db side of the project and i decided to use
> them as much as possible.... you can find an article about SPs on
> interbase web site, that applies to SPs in general, too.
> i actually haven't found drawbacks in SPs, so if your group is
> pointing out something against SPs, well i'll be pleased if you could
> let me know that.... we might even discuss about it.
> Roberto Padovani
> ----------------
> ICQ#125729644
> ----------------
Received on Sat Sep 08 2001 - 18:34:49 CDT

Original text of this message