In this post, you’ll learn more about the Oracle ErrorORA-06561: given statement is not supported by package DBMS_SQL with the details on why you receive this error and the possible solution to fix it.
Oracle Error Description
ORA-06561: given statement is not supported by package DBMS_SQL
Reason for the Error ORA-06561: given statement is not supported by package DBMS_SQL
Attempting to parse an unsupported statement using procedure PARSE provided by package DBMS_SQL.
How to fix the Error ORA-06561: given statement is not supported by package DBMS_SQL ?
You can fix this error in Oracle by following the below steps
Only statements which begin with SELECT, DELETE, INSERT, UPDATE, LOCK, BEGIN, DECLARE or << (PL/SQL label delimiter) are supported.