Oracle Error ORA-06539: target of OPEN must be a query

Oracle Error Message

ORA-06539: target of OPEN must be a query

Reason for the Error

The program attempted to perform an OPEN cursor operation on a dynamic statement that was not a query.

Solution

Ensure that the OPEN cursor operation is done on a dynamic query statement. ——————————————————– 06540 through 06549 reserved for pl/sql error handling