Oracle Error PLS-00950: In this version, PL/SQL tables can not be used in this SQL statement.

Oracle Error Message

PLS-00950: In this version, PL/SQL tables can not be used in this SQL statement.

Reason for the Error

In a SQL statement, a PL/SQL table was referenced incorrectly. For example, the following reference might have been made, but PL/SQL table attributes can only be used in procedural statements: SELECT ename_tab.COUNT INTO name_count WHERE …

Solution

Remove the incorrect reference from the SQL statement.