Re: encapsulating tables in pl/sql packages?

From: Tanel Poder <tanel.poder.003_at_mail.ee>
Date: Sun, 1 Feb 2004 06:22:45 +0200
Message-ID: <065b01c3e87b$0b2966f0$72f923d5@porgand>

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_at_cox.net> To: <oracle-l_at_freelists.org> 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_at_freelists.org
> 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_at_freelists.org 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
-----------------------------------------------------------------

Received on Sat Jan 31 2004 - 22:22:45 CST