orcl>
orcl> CREATE OR REPLACE PROCEDURE exec_ddl(ddl_string IN VARCHAR2)
  2  IS
  3  BEGIN
  4  EXECUTE IMMEDIATE ddl_string;
  5  END;
  6  /

Procedure created.

orcl> BEGIN
  2  exec_ddl('CREATE TABLE sam_tab (sam_num NUMBER(4))');
  3  END;
  4  /
BEGIN
*
ERROR at line 1:
ORA-01031: insufficient privileges
ORA-06512: at "JON.EXEC_DDL", line 4
ORA-06512: at line 2


orcl> grant create table to jon;

Grant succeeded.

orcl> BEGIN
  2  exec_ddl('CREATE TABLE sam_tab (sam_num NUMBER(4))');
  3  END;
  4  /

PL/SQL procedure successfully completed.

orcl>