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.
Note:
The use ofREF CURSOR queries in Oracle Reports 12c (12.2.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 12c (12.2.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[55916] 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 12c (12.2.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 12c (12.2.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 12c (12.2.1.1) client invokes a PL/SQL unit in a 10.1 or 10.2 database using RPC.