How to fix the Oracle error QSM-00791: the specified SQL statement cannot be stored in the workload because is contains unsupported statement type?

In this post, you’ll learn more about the Oracle ErrorQSM-00791: the specified SQL statement cannot be stored in the workload because is contains unsupported statement type with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

QSM-00791: the specified SQL statement cannot be stored in the workload because is contains unsupported statement type

Reason for the Error QSM-00791: the specified SQL statement cannot be stored in the workload because is contains unsupported statement type

The user attempted to add a workload statement that contains an invalid statement type. Supported statement types are INSERT, DELETE, UPDATE, SELECT and MERGE.

How to fix the Error QSM-00791: the specified SQL statement cannot be stored in the workload because is contains unsupported statement type ?

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

Validate the workload statement and retry the operation.