title: Using 'Insert Into' with an 'update' keyword in an Explicit Cursor
body: <p>Running the script below, produces the error:</p>
  <p>*&quot;Error report -
  ORA-06550: line 19, column 15:
  PL/SQL: ORA-00942: table or view does not exist
  ORA-06550: line 19, column 1:
  PL/SQL: SQL Statement ignored
  06550. 00000 -  &quot;line %s, column %s:\n%s&quot;
  *Cause:    Usually a PL/SQL compilation error.
  <em>Action:
  &quot;</em></p>
  <pre><code>DECLARE
  h_d_regionID departments.region%TYPE;
  h_l_countryID locations.country_id%TYPE;
  
  CURSOR DCursor IS
  SELECT  d.region --,l.country_id
  FROM locations l 
  inner join departments d
  on d.location_id = l.location_id
  FOR UPDATE;
  BEGIN
  OPEN DCursor;
  LOOP
  FETCH DCursor INTO h_l_countryID;
  EXIT WHEN DCursor%NOTFOUND;
  /* Delete the current tuple: */
  --DELETE FROM departments.region WHERE CURRENT OF DCursor;
  /* Insert the reverse tuple: */
  INSERT INTO d.region VALUES(h_d_regionID);
  
  END LOOP;
  /* Free cursor used by the query. */
  CLOSE DCursor;
  END;
  </code></pre>
  <p>What am I missing here?</p>