PL/SQL Package for Indirect Referencing

Visit the PL/SQL Pipeline for free technical articles, code samples, packages, presentations, discussion groups and PL/SQL 'brain-teasers". The PL/SQL Pipeline is a free internet community for Oracle developers hosted by Steven Feuerstein, and sponsored by RevealNet. You can access the Pipeline by poointing your website to
http://www.revealnet.com/plsql-pipeline/index.htm

Implementation of Indirect Referencing
By Steven Feuerstein

This month's addition to the PL/SQL Pipeline Archive offers a package which implements indirect referencing. In other words, it lets you retrieve and set the values of PL/SQL variables (in some cases only those defined in a package specification) by referencing their names and not the variable themselves. This is similar to the NAME_IN and COPY functionality of Oracle Forms.

The explanation and code for this utility comes from the upcoming Oracle Built-in Packages, written by Steven Feuerstein, Charles Dye and John Beresniewicz and published by O'Reilly and Associates (May 1998).

Finally, the 1998 Q1 release of PL/Vision Professional will feature PLVvar, a comprehensive implementation of indirect referencing. The package specification for PLVvar is included in the zip. Format: zipped file, 15K. Received on Mon Jan 26 1998 - 00:00:00 CST