Recent content by stewartb

  1. S

    Select for update (with database link)

    Not knowing how PL/SQL Developer works in this area I tried to write an SQL*Plus "equivalent" as follows - which works fine. DECLARE CURSOR c1 IS SELECT title FROM schema.table@db_link t FOR UPDATE OF title; v1 c1%ROWTYPE; BEGIN OPEN c1; FETCH c1 INTO v1...
  2. S

    Select for update (with database link)

    When I try to execute the following statement: SELECT t.* from schema.table@db_link t FOR UPDATE The statement executes fine (and returns rows) but as soon as I click the "Edit Data" padlock icon I get the error message: "These query results are not updateable. Include the ROWID to get...
Back
Top