Re: encapsulating tables in pl/sql packages?

No experiences on it, but reduced performance and additional bugs are
possible drawbacks of this approach. The Optimizer probably doesn't have
free hands for putting together the execution plans either.

Tanel.

----- Original Message ----- 
From: "Ryan" <ryan.gaffuri@xxxxxxx>
To: <oracle-l@xxxxxxxxxxxxx>
Sent: Sunday, February 01, 2004 5:57 AM
Subject: encapsulating tables in pl/sql packages?


> Steve Fuerstein has written on this extensively and I heard a guy speak on
this recently. I was wondering if anyone tried this. Instead of giving
developers direct sql access to tables, each table is wrapped in a package
and the developers call those packages to perform select and DML statements
on the tables.
> if you have done this, please post your experiences.
>
> ----------------------------------------------------------------
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> ----------------------------------------------------------------
> To unsubscribe send email to:  oracle-l-request@xxxxxxxxxxxxx
> put 'unsubscribe' in the subject line.
> --
> Archives are at http://www.freelists.org/archives/oracle-l/
> FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
> -----------------------------------------------------------------
>


----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to:  oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Other related posts: