Re: Retrieving data using views & stored procedures. (doing it right?)

You are getting dangerously close here to asking people what the best religion is ... but from where I sit I never allow direct table access. And I don't particularly like views. My preference is procedures inside of packages. They are the fastest, safest, easiest to debug, and most versatile.

Others undoubtedly will disagree.

Daniel A. Morgan

Charles McDonald wrote:

> Hi all
>
> We are about to embark on a new development where the dB will be 8i. Now
> I have read a few references about accessing data in the dB by use of
> stored procedures, functions and views rather than direct table access.
>
> What is the *right* way? Soley stored procedures & views, a hybrid or
> direct access to the tables?
>
> Cheers
> Charles
Received on Thu Apr 12 2001 - 00:46:35 CDT