Binding a PL/SQL index-by table to SQL

Before 12.1, you could invoke a function with a collection actual, or select from a collection, but

• The type had to be defined at schema level
• Therefore it had to be a nested table or a varray
• A non-scalar payload had to be an ADT

Now in 12.1

• The type can be defined in a package spec – can be index by pls_integer table
•  The payload can be a record – but the fields must still be SQL datatypes

Example: 

binding an IBPI to a PL/SQL function in SQL

Example:

   binding to the operand of the table operator