PLS-00405

Error: PLS-00405: subquery not allowed in this context

Causa: A subquery was used in an inappropriate context, such as:

Acción: The same result can be obtained by using a temporary variable, as in: