Devart Forums

Code: Select all

DECLARE
  updatedRowid ROWID;
BEGIN
UPDATE TUSERS
   SET LASTLOGINTIME = :p0
 WHERE ID = :p1 AND TS = :p2
RETURNING ROWID INTO updatedRowid;
OPEN :outParameter FOR SELECT TS FROM TUSERS WHERE ROWID = updatedRowid;
END;

Code: Select all

BEGIN
UPDATE TUSERS
   SET LASTLOGINTIME = :p0
 WHERE ID = :p1 AND TS = :p2;
OPEN :outParameter FOR SELECT TS FROM TUSERS WHERE ID = :p1;
END;

Code: Select all

DECLARE
  RC$ NUMBER;

BEGIN

UPDATE MYTABLE
SET LASTLOGINTIME = :p0 
WHERE ID = :p1 AND TS = :p2;

RC$ := SQL%ROWCOUNT;

OPEN :outParameter FOR 
SELECT TS,...[other Sync OnUpdate columns] FROM MYTABLE
WHERE ID = :p1 AND RC$ > 0;

END;