title: Regarding Execute Immediate in stored procedure
body: <p>I am having the below statement from stored procedure. It's giving Insufficient Privileges.
  But If i run the create statement alone from the sql prompt it's creating table.  </p>
  
  <pre><code>    execute immediate 'create table TEST_ABC(
                      NO_AC NUMBER(8) 
                      , ILL_PER VARCHAR2(15)
                      , INIT_C DATE
                      )';
  </code></pre>
  
  <p>What needs to be done to have priviliges to create table via execute immediate from stored procedure. Not sure how it's working from sql command prompt</p>