Re: pl/sql table

In article <31e98192.392882_at_news.indy.net>, Ivan Samuelson <bolski_at_indy.net> wrote:

>....THIS is the beauty of PL/SQL tables. At first, I too felt they were
useless. Now, I've gone back to many programs I've written and rewrote them to use PL/SQL tables with this kind of programming.

         A project I have been working on has utilized PL/SQL procedures that were stored within Oracle Forms (version 4.5) . The architecture of the system is being changed to client/server, so it makes sense to restructure these procedures by incorporating them into PL/SQL Packages that are stored on the database server. When these procedures were originally implemented they utilized "record groups", which are an internal Oracle Forms da ta structure that has a similar column/row framework to a database table. Since this record group structure is not supported by PL/SQL code running on the server, the PL/SQL tables that you have described become useful as a substitute method for performing the same data manipulation operations (such as computing partial sums) that had utilized these record groups.

• Bill Angel