Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.tools -> Re: Retrieving data using views & stored procedures. (doing it right?)
First I'd say that the most important is to choose one paradigm, and stick to it.
If I had to do it all again, I'd use views, and procedures / functions. You can query individual pieces of data using a function, and access result sets through a view whose WHERE clause depends on the current context, set as variables in a package.
hth
"Charles McDonald" <cmcdon12_at_nospam.ford.com> wrote in message
news:3AD454A4.4DAE0B86_at_nospam.ford.com...
> 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 - 02:23:50 CDT
![]() |
![]() |