Oracle Error ORA-33275: Autonomous transaction query of an UPDATEd analytic workspace is not supported

Oracle Error Message

ORA-33275: Autonomous transaction query of an UPDATEd analytic workspace is not supported

Reason for the Error

The user made attempt to reference an anayltic workspace that has uncommited updates within an autonomous query.

Solution

Either COMMIT or ROLLBACK your uncommited changes, or don’t use an autonomous transaction.