SQL> create or replace procedure P_test_err is
2 begin3 execute immediate 'create table t(id number)';
4 end;
5 /
Procedure created.
SQL> call p_test_err();
call p_test_err()
*
ERROR at line 1:
ORA-01031: insufficient privileges
ORA-06512: at "TEST.P_TEST_ERR", line 3
SQL> grant create any table to test;
Grant succeeded.
SQL> call p_test_err();
Call completed.
SQL> select * from t;
no rows selected