The stored procedure is as follows:
Create Or Replace Procedure Proc_TMP IS
Dynamic_SQL VARCHAR2 (100);
Begin
Dynamic_sql: = 'CREATE TABLE T_TMP (a varchar2 (24), b varchar2 (24))';
Execute immediate dynamic_sql;
END;
Tip has no permissions, what is the reason?