PL/SQL Package for Indirect Referencing
Date: 1998/01/26
Message-ID: <01bd2a7d$71ca3dc0$4d73b1cd_at_Preveal2>#1/1
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 CET