Re: encapsulating tables in pl/sql packages?
- From: "Tanel Poder" <tanel.poder.003@xxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Sun, 1 Feb 2004 06:22:45 +0200
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 //www.freelists.org/archives/oracle-l/
> FAQ is at //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 //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
