https://wiki.ispirer.com/ 2026-04-21T12:10:48+00:00 https://wiki.ispirer.com/ https://wiki.ispirer.com/lib/tpl/dokuwiki/images/favicon.ico text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/oracle/conversions/hirdb/plsql_conversion/package?rev=1741078744&do=diff User Documentation Ispirer Capabilities - Oracle Migration Pricing 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… text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/oracle/conversions/hirdb/plsql_conversion/plsql_block?rev=1741078744&do=diff User Documentation Ispirer Capabilities - Oracle Migration Pricing Oracle PL/SQL block to HiRDB PL/SQL Block convert to HiRDB SQL Stored Procedure. Procedure_name is fixed name. Oracle: DECLARE num NUMBER; BEGIN n :=1; BEGIN n1 :=2; END; n2 :=3; END; HiRDB: CREATE PROCEDURE pr_name() BEGIN DECLARE num FLOAT; SET n = 1; BEGIN SET n1 = 2; END; SET n2 = 3; END; END_PROC text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/oracle/conversions/hirdb/plsql_conversion/stored_procedures?rev=1741078744&do=diff User Documentation Ispirer Capabilities - Oracle Migration Pricing Oracle Stored Procedure to HiRDB If “OR REPLACE” is specified , remove “OR REPLACE”. If “AS” token is specified, remove “AS” as with “IS” token. Add “END_PROC” after “END;” token. Or if “procedure_name” is specified after END , replace