To build the example in this chapter, you must have the example files provided, as well as access to the Human Resources sample schema (HR) provided with the Oracle Database. If you do not know if you have access to this sample schema, contact your database administrator.
The use of
REF CURSOR queries in Oracle Reports 11g Release 1 (11.1.1) requires that your database version is 10.1.0.5 (for 10.1) or 10.2.0.2 (for 10.2) or higher.
Interoperability between a 11g Release 1 (11.1.1) database or Oracle Forms Services client and a 10.1/10.2 database requires a minimum patchset level of 10.1.0.5 (for 10.1) or 10.2.0.2 (for 10.2).
An attempt to reference a 10.1 or 10.2 PL/SQL unit or view under the following circumstances will fail with a
PLS-801 error unless the 10.1 or 10.2 environment has been patched to the right level:
A PL/SQL unit, anonymous block, trigger, call statement, or SQL statement on a 11g Release 1 (11.1.1) database invokes a PL/SQL unit on a 10.1 or 10.2 database across a database link.
A PL/SQL unit, anonymous block, trigger, or call statement on a 11g Release 1 (11.1.1) database references a view on a 10.1 or 10.2 database across a database link and the view directly or indirectly references a PL/SQL function or an object type.
An Oracle Forms Services 11g Release 1 (11.1.1) client invokes a PL/SQL unit in a 10.1 or 10.2 database using RPC.