| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: encapsulating tables in pl/sql packages?
I am now in the final negotiations with one customer to help them to resolve
some performance issues. One of the known problems they have is their FORMS
and PL/SQL code that uses such kind of approach. I don't know exactly if
they use the code you mention. Some time ago they compared this kind of
approach with direct one and they found that packaged approach introduces
quite a significant overhead. They are often beyond the edge of the capacity
of their system and therefore they are looking for all possible
improvements.
Joze
-----Original Message-----
From: Ryan [mailto:ryan.gaffuri_at_cox.net]
Sent: Sunday, February 01, 2004 4:57 AM
To: oracle-l_at_freelists.org
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.
 |
 |