SQL> connect sys as sysdba
Enter password:
Connected.
SQL> grant dba to temp;

Grant succeeded.

SQL> connect temp
Enter password:
Connected.
SQL>
SQL> create or replace procedure tempproc
  2  is
  3  begin
  4  execute immediate 'create table temp_table(a varchar2(10))';
  5  end;
  6  /

Procedure created.

SQL> exec tempproc;
BEGIN tempproc; END;

*
ERROR at line 1:
ORA-01031: insufficient privileges
ORA-06512: at "TEMP.TEMPPROC", line 4
ORA-06512: at line 1


SQL>
SQL> declare
  2  begin
  3  execute immediate 'create table temp_table(a varchar2(10))';
  4  end;
  5  /

PL/SQL procedure successfully completed.

SQL> desc temp_table;
 Name                                      Null?    Type
 ----------------------------------------- -------- ----------------------------
 A                                                  VARCHAR2(10)