Ispirer Website Ispirer Capabilities - Oracle Migration Free Trial

Oracle CURSOR to HiRDB

Oracle Cursor changed to the cursor in procedure in HiRDB.

Oracle:

DECLARE CURSOR item_cur (curpar1 IN number := 3, curpar2 number) IS
SELECT distributor_id  FROM t1;
var float := 5;
BEGIN
 var :=4;
end;

HiRDB:

CREATE PROCEDURE cur_conv()
BEGIN
 DECLARE curpar1 FLOAT DEFAULT 3;
 DECLARE curpar2 FLOAT;
 DECLARE var FLOAT DEFAULT 5;
 DECLARE ITEM_CUR  CURSOR FOR SELECT distributor_id  FROM t1;
 SET var = 4;
 end;
 END_PROC

© 1999-2024, Ispirer Systems, LLC. All Rights Reserved.