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