title: ORA-32462: cannot use an object modified in current transaction
body: <p>Note: This is in Oracle 18c</p>
  
  <p>There is one insert happening on temp1 table, then I am calling one of the child stored procedure just after this insert statement. In this stored procedure, I have created PTT(PRIVATE TEMPORARY TABLE) having this 'temp1' table used as below:</p>
  
  <pre><code>Insert into temp1(name, dept, date) values ('A','HR',sysdate);
  
  CREATE PRIVATE TEMPORARY TABLE ora$pgtt
   as
   select dept from temp1 where dept ='HR' and name ='A';
  </code></pre>
  
  <p>But I am getting an error:</p>
  
  <blockquote>
    <p>ORA-32462: cannot use an object modified in current transaction</p>
  </blockquote>