Ispirer Website
Ispirer Capabilities - Oracle Migration
Free Trial
Oracle Package to HiRDB
Package convert to HiRDB Stored procedure that devide by each body. Also package's variable convert to each procedurer's Parameter (INOUT) if it is used inside the procedure.
Oracle:
CREATE [OR REPLACE] PACKAGE package_name AS num NUMBER; PROCEDURE procedure_name_1; PROCEDURE procedure_name_2; END[package_name]; / CREATE [OR REPLACE] PACKAGE BODY package_name AS PROCEDURE procedure_name_1 AS BEGIN num :=1; END[procedure_name_1]; PROCEDURE procedure_name_2 AS BEGIN ….. END[procedure_name_2]; END[package_name];
HiRDB:
CREATE PROCEDURE procedure_name_1(INOUT “NUM” FLOAT) BEGIN …. END END_PROC; CREATE PROCEDURE procedure_name_2(INOUT “NUM” FLOAT) BEGIN …. END; END_PROC;