How to fix the Oracle error ORA-38815: ALTER SESSION SET EDITION must be a top-level SQL statement?

In this post, you’ll learn more about the Oracle ErrorORA-38815: ALTER SESSION SET EDITION must be a top-level SQL statement with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

ORA-38815: ALTER SESSION SET EDITION must be a top-level SQL statement

Reason for the Error ORA-38815: ALTER SESSION SET EDITION must be a top-level SQL statement

An edition switch failed because it was executed from a PL/SQL block or using recursive SQL.

How to fix the Error ORA-38815: ALTER SESSION SET EDITION must be a top-level SQL statement ?

You can fix this error in Oracle by following the below steps

Execute the statement from a top-level OCI call, or use dbms_session.set_edition if its deferred effect is appropriate.