Re: Do you use PL/SQL

On 25 mai, 06:40, Galen Boyer <galen_bo..._at_yahoo.com> wrote:
> On 23 May 2007, hasta..._at_hotmail.com wrote:
>
> > On 24 mai, 01:53, DA Morgan <damor..._at_psoug.org> wrote:
> >> zigzag..._at_yahoo.com wrote:
> >> > In practice,youcannot make your application as database
> >> > independent by writing lots of stored procedures inPL/SQL. That's
> >> > the reason people avoidPL/SQLbecause it is a proprietary Language
> >> > of Oracle.
>
> >> Sorry but that's nonsense.Youcan doit and the better companies with
> >> the better productsdodoit.
>
> > Daniel, I have to say with Zizag that having to maintain
> > synchronized a sizeable code base of stored procedures
> > in three or four dialects is for me a *very* frightening
> > perspective.
>
> I really don't see how it is such a big deal.

Galen, it is hard to to keep three or four different implementations synchronized with an evolving common specification.

"Avoid code duplication" is a basic rule of software development.

> To me it is easier to get that accurate across all platforms
> than trying to do it within a single app.

Certainly. Doing it in the app is even harder, if one does not restricts himself to a common lowest denominator.

I tend to believe, somewhat with Mladen, that the problem has no solution if one requires a system that is simultaneously

• Somewhat large
• Fast and robust
• Reasonnably affordable
• Database independent

One of the requirement has to go

have a very nice day

• Raoul