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;

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