Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> Re: Retrieving data using views & stored procedures. (doing it right?)

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

From: Ian Ledzion <ian.ledzion_at_lgxbow.com>
Date: Thu, 12 Apr 2001 09:23:50 +0200
Message-ID: <9b3l5r$an4$1@rex.ip-plus.net>

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US