title: Update statement not working getting error ORA-01031: Insufficient privileges
body: <p>My update table query not working. if i am runing this query as a sub part it's working but as soon as i am runing as a whole it giving me exception  ORA-01031: Insufficient privileges. </p>
  
  <pre><code> declare
           var_sqlString varchar2(2500);
           begin    
      var_sqlString :='UPDATE (select ''A''||registration_id from sde.table_registry where table_name=''OPENPOINT'' and OWNER=''EDGIS'') 
      SET OPERATINGVOLTAGE=''21'' where GLOBALID=''{3B5C4257-12D8-4CA9-82E4-427AC9D79BB0}''' ;
      dbms_output.put_line(var_sqlString); 
            EXECUTE immediate var_sqlString;
            commit;        
           end;
  </code></pre>
  
  <p>When i am executing this query <code>dbms_output.put_line</code> giving me bellow result.</p>
  
  <pre><code>UPDATE (select 'A'||registration_id from sde.table_registry where table_name='OPENPOINT' and OWNER='EDGIS') 
  SET OPERATINGVOLTAGE='21' where GLOBALID='{3B5C4257-12D8-4CA9-82E4-427AC9D79BB0}'
  </code></pre>
  
  <p>And when i am runing the above query than also i am getting the same error. Now the problem is when i am executing part one which is: <code>select 'A'||registration_id from sde.table_registry where table_name='OPENPOINT' and OWNER='EDGIS'</code>
  Its giving me the result  which is <code>A126</code> and then i am passing that result in my update statement, the update statement works fine. But as a whole is not working .....???</p>