While running the Quick Start test "Delete_Mult_Rows" the following error appears:
=============
Error executing "CREATE TABLE Q##COPY_1346090029 ( N ) AS SELECT N FROM QCTOD#DMR_TABLE"
ORA-01031: insufficient privileges
PL/SQL Error Backtrace:
ORA-06512: at "SCHEMA_NAME.Q##QCTOD#DELETE_MULT_ROWS", line 530
=============
However, when connecting to the same account and database using Toad, the CREATE TABLE statement worked successfully.
The problem is caused by Code Tester wanting to create global temporary tables from within an "execute immediate" statement in a package.
Ensure CREATE TABLE privileges are granted to the Oracle account being used for the test.
Please make sure the privilege is granted directly to the user (if the user has RESOURCE privilege it will not work even if this role inherits CREATE TABLE)
