Oracle Error ORA-29474: DBMS_SQL.OPEN_CURSOR failed. security_level of 0 is not allowed

Oracle Error Message

ORA-29474: DBMS_SQL.OPEN_CURSOR failed. security_level of 0 is not allowed

Reason for the Error

Security level of 0 is specified with DBMS_SQL.OPEN_CURSOR.

Solution

Specify a valid security level.