Ispirer Migration Knowledge Base sqlways:oracle:conversions:hirdb:bl_conversion:procedures

Oracle Assignment Operator := to HiRDB

Anonymous (anonymous@undisclosed.example.com) — 2025-03-04T08:59:04+00:00

User Documentation Ispirer Capabilities - Oracle Migration Pricing Oracle Assignment Operator := to HiRDB Remove “:” and add “SET” at the top of the assignment statement. Oracle: variable_name := value; HiRDB: SET variable_name = value;

Oracle Boolean to HiRDB

Anonymous (anonymous@undisclosed.example.com) — 2025-03-04T08:59:04+00:00

User Documentation Ispirer Capabilities - Oracle Migration Pricing Oracle Boolean to HiRDB Change TRUE to '1' and FALSE to '0'. Oracle: TRUE HiRDB: 1 Oracle: FALSE HiRDB: O

Oracle CLOSE cursor to HiRDB

Anonymous (anonymous@undisclosed.example.com) — 2025-03-04T08:59:04+00:00

User Documentation Ispirer Capabilities - Oracle Migration Pricing Oracle CLOSE cursor to HiRDB There is no need to change Oracle close cursor. Oracle: CLOSE cursor_name; HiRDB: CLOSE cursor_name;

Oracle Comment to HiRDB

Anonymous (anonymous@undisclosed.example.com) — 2025-03-04T08:59:04+00:00

User Documentation Ispirer Capabilities - Oracle Migration Pricing Oracle Comment to HiRDB All comment part convert to '/*～*/'. Oracle: /* comment1 */ | -- comment2 | REM[ARK] comment3 HiRDB: /* comment1 */ | /* comment2 */ | /* comment3 */

Oracle CONSTANT declaration to HiRDB

Anonymous (anonymous@undisclosed.example.com) — 2025-03-04T08:59:04+00:00

User Documentation Ispirer Capabilities - Oracle Migration Pricing Oracle CONSTANT declaration to HiRDB 'NOT NULL' is not supported on HiRDB.So if 'NOT NULL' is specified , remove 'NOT NULL'. And ':=' fix 'DEFAULT'. Oracle: constant_name CONSTANT data_ type [NOT NULL] {:=|DEFAULT} default_value; HiRDB: DECLARE constant_name　data_type [DEFAULT default_value] ;

Oracle cursor_name%FOUND to HiRDB

Anonymous (anonymous@undisclosed.example.com) — 2025-03-04T08:59:04+00:00

User Documentation Ispirer Capabilities - Oracle Migration Pricing Oracle cursor_name%FOUND to HiRDB Oracle Curname%FOUND changed to its equivalent in HiRDB. Add message “/*This conversion has inappropriate possibility*/”. Oracle: IF Curname%FOUND then exit; end if; HiRDB: IF SQLCODE<>100 then leave; end if; /*This conversion has inappropriate possibility*/

Oracle cursor_name%NOTFOUND to HiRDB

Anonymous (anonymous@undisclosed.example.com) — 2025-03-04T08:59:04+00:00

User Documentation Ispirer Capabilities - Oracle Migration Pricing Oracle cursor_name%NOTFOUND to HiRDB Oracle Curname%NOTFOUND changed to its equivalent in HiRDB. Add message “/*This conversion has inappropriate possibility*/”. Oracle: IF Curname%NOTFOUND then exit; end if; HiRDB: IF SQLCODE=100 then leave; end if; /*This conversion has inappropriate possibility*/

Oracle cursor_name%ROWCOUNT to HiRDB

Anonymous (anonymous@undisclosed.example.com) — 2025-03-04T08:59:04+00:00

User Documentation Ispirer Capabilities - Oracle Migration Pricing Oracle cursor_name%ROWCOUNT to HiRDB Oracle Curname%ROWCOUNT changed to its equivalent in HiRDB. Add message “/*This conversion has inappropriate possibility*/”. Oracle: IF Curname%ROWCOUNT then exit; end if; HiRDB: IF SQLCOUNT then leave; end if; /*This conversion has inappropriate possibility*/

Oracle CURSOR to HiRDB

Anonymous (anonymous@undisclosed.example.com) — 2025-03-04T08:59:04+00:00

User Documentation Ispirer Capabilities - Oracle Migration Pricing 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 = …

Oracle DBMS_OUTPUT.PUT_LINE to HiRDB

Anonymous (anonymous@undisclosed.example.com) — 2025-03-04T08:59:04+00:00

User Documentation Ispirer Capabilities - Oracle Migration Pricing Oracle DBMS_OUTPUT.PUT_LINE to HiRDB Replace “DBMS_OUTPUT.PUT_LINE” to “WRITE LINE”. Oracle: DBMS_OUTPUT.PUT_LINE (expr); HiRDB: WRITE LINE (expr);

Oracle DECLARE EXCEPTION to HiRDB

Anonymous (anonymous@undisclosed.example.com) — 2025-03-04T08:59:04+00:00

User Documentation Ispirer Capabilities - Oracle Migration Pricing Oracle DECLARE EXCEPTION to HiRDB Oracle EXCEPTION changed to DECLARE CONDITION. Oracle: exception_name EXCEPTION HiRDB: DECLARE exception_name CONDITION

Oracle Exception Handler to HiRDB

Anonymous (anonymous@undisclosed.example.com) — 2025-03-04T08:59:04+00:00

User Documentation Ispirer Capabilities - Oracle Migration Pricing Oracle Exception Handler to HiRDB Oracle Exception to Exception Handler. Oracle: WHEN { exception_name1 [OR exception_name2] ... | OTHERS } THEN statement ; [statement ; ] ... ] HiRDB: DECLARE { CONTINUE | EXIT } HANDLER FOR { SQLERROR | NOT FOUND | exception_name1 | SQLCODE VALUE sqlcode_value1 } [ , { SQLERROR | NOT FOUND | exception_name2 | SQLCODE VALUE sqlcode_value2 } ] ... statement ; [statement ; ] ...

Oracle EXCEPTION_INIT to HiRDB

Anonymous (anonymous@undisclosed.example.com) — 2025-03-04T08:59:04+00:00

User Documentation Ispirer Capabilities - Oracle Migration Pricing Oracle EXCEPTION_INIT to HiRDB PRAGMA EXCEPTION_INIT changed to DECLARE CONDITION FOR SQLCODE VALUE Oracle: PRAGMA EXCEPTION_INIT( exception_name, sqlcode_value ) HiRDB: DECLARE exception_name CONDITION FOR SQLCODE VALUE sqlcode_value

Oracle EXECUTE IMMEDIATE to HiRDB

Anonymous (anonymous@undisclosed.example.com) — 2025-03-04T08:59:04+00:00

User Documentation Ispirer Capabilities - Oracle Migration Pricing Oracle EXECUTE IMMEDIATE to HiRDB Remove “EXECUTE IMMEDIATE” and “'” Token. Oracle: EXECUTE IMMEDIATE ‘statement’; HiRDB: statement;

Oracle EXIT … WHEN to HiRDB

Anonymous (anonymous@undisclosed.example.com) — 2025-03-04T08:59:04+00:00

User Documentation Ispirer Capabilities - Oracle Migration Pricing Oracle EXIT … WHEN to HiRDB Replace “EXIT” to “LEAVE”. And “WHEN condition” convert to “IF” syntax. Oracle: EXIT [label_name] WHEN condition; HiRDB: IF condition THEN LEAVE [label_name]; END IF;

Oracle EXIT to HiRDB

Anonymous (anonymous@undisclosed.example.com) — 2025-03-04T08:59:04+00:00

User Documentation Ispirer Capabilities - Oracle Migration Pricing Oracle EXIT to HiRDB Replace “EXIT” to “LEAVE”. Oracle: EXIT [label_name]; HiRDB: LEAVE [label_name];

Oracle FETCH to HiRDB

Anonymous (anonymous@undisclosed.example.com) — 2025-03-04T08:59:04+00:00

User Documentation Ispirer Capabilities - Oracle Migration Pricing Oracle FETCH to HiRDB There is no need to change Oracle Fetch.Syntax is equal. Oracle: FETCH cursor_name INTO variable_name [,variable_name]… ; HiRDB: FETCH cursor_name INTO variable_name [,variable_name]… ;

Oracle FOR LOOP cursor (cursorname is omitted) to HiRDB

Anonymous (anonymous@undisclosed.example.com) — 2025-03-04T08:59:04+00:00

User Documentation Ispirer Capabilities - Oracle Migration Pricing Oracle FOR LOOP cursor (cursorname is omitted) to HiRDB Oracle FOR LOOP changed to FOR DO. Oracle: BEGIN <> FOR item IN SELECT last_name, job_id FROM employees WHERE job_id LIKE '%CLERK%' AND manager_id > 120 LOOP DBMS_OUTPUT.PUT_LINE (item.full_name); END LOOP l_name; END;

Oracle FOR LOOP cursor (cursorname is specified) to HiRDB

Anonymous (anonymous@undisclosed.example.com) — 2025-03-04T08:59:04+00:00

User Documentation Ispirer Capabilities - Oracle Migration Pricing Oracle FOR LOOP cursor (cursorname is specified) to HiRDB FOR LOOP with cursor name changed to the FOR DO with CURSOR. Oracle: DECLARE CURSOR c1 (para INT) IS SELECT last_name, job_id FROM employees WHERE job_id LIKE '%CLERK%' AND manager_id > 120; BEGIN <> FOR item IN c1(10) LOOP DBMS_OUTPUT.PUT_LINE (item.full_name); END LOOP l_name; END;

Oracle FOR LOOP … IN REVERSE to HiRDB

Anonymous (anonymous@undisclosed.example.com) — 2025-03-04T08:59:04+00:00

User Documentation Ispirer Capabilities - Oracle Migration Pricing Oracle FOR LOOP … IN REVERSE to HiRDB SQLWays changes FOR LOOP REVERSE statement to WHILE statement. Before WHILE statement SQLWays declares INT variable and sets it upper value of loop range. This variable is decremented by 1 in WHILE statement on each iteration. WHILE loop will work till this variable more or equal when lower value of loop range.

Oracle FOR LOOP to HiRDB

Anonymous (anonymous@undisclosed.example.com) — 2025-03-04T08:59:04+00:00

User Documentation Ispirer Capabilities - Oracle Migration Pricing Oracle FOR LOOP to HiRDB SQLWays changes FOR LOOP statement to WHILE statement. Before WHILE statement SQLWays declares INT variable and sets it lower value of loop range. This variable is incremented by 1 in WHILE statement on each iteration. WHILE loop will work till this variable less or equal when upper value of loop range.

Oracle IF to HiRDB

Anonymous (anonymous@undisclosed.example.com) — 2025-03-04T08:59:04+00:00

User Documentation Ispirer Capabilities - Oracle Migration Pricing Oracle IF to HiRDB If “ELSIF” is using , replace “ELSIF” to ELSEIF Oracle: IF condition THEN statement; [statement;]… [ELSIF condition THEN statement; [statement;]…]… [ELSE statement; [statement;]…] END IF; HiRDB: IF condition THEN statement; [statement;]… [ELSEIF condition THEN statement; [statement;]…]… [ELSE statement; [statement;]…] END IF;

Oracle LOOP to HiRDB

Anonymous (anonymous@undisclosed.example.com) — 2025-03-04T08:59:04+00:00

User Documentation Ispirer Capabilities - Oracle Migration Pricing Oracle LOOP to HiRDB SQLWays changes LOOP statement to WHILE statement. 'LOOP' is replaced with 'WHILE 1=1 DO' and 'END LOOP' is replaced with 'END WHILE'. Oracle: Declare empno number; Begin empno := 2; <> loop empno := empno + 1; if empno > 5 then exit; end if; end loop label_name; end;

Oracle OPEN cursor with parameters to HiRDB

Anonymous (anonymous@undisclosed.example.com) — 2025-03-04T08:59:04+00:00

User Documentation Ispirer Capabilities - Oracle Migration Pricing Oracle OPEN cursor with parameters to HiRDB Oracle cursor with parameters converts to cursor without parameters. Oracle: OPEN cursor_name (parameter1[, parameter2]…); HiRDB: OPEN cursor_name;

Oracle OPEN cursor without parameters to HiRDB

Anonymous (anonymous@undisclosed.example.com) — 2025-03-04T08:59:04+00:00

User Documentation Ispirer Capabilities - Oracle Migration Pricing Oracle OPEN cursor without parameters to HiRDB There is no need to change Oracle open cursor. Oracle: OPEN cursor_name; HiRDB: OPEN cursor_name;

Oracle RAISE exception_name to HiRDB

Anonymous (anonymous@undisclosed.example.com) — 2025-03-04T08:59:04+00:00

User Documentation Ispirer Capabilities - Oracle Migration Pricing Oracle RAISE exception_name to HiRDB If exception_name is specified , Replace “RAISE” to “SIGNAL”. Oracle: RAISE exception_name; HiRDB: SIGNAL exception_name ;

Oracle RAISE to HiRDB

Anonymous (anonymous@undisclosed.example.com) — 2025-03-04T08:59:04+00:00

User Documentation Ispirer Capabilities - Oracle Migration Pricing Oracle RAISE to HiRDB Replace “RAISE” to “RESIGNAL”. Oracle: RAISE ; HiRDB: RESIGNAL;

Oracle RETURN (in function) to HiRDB

Anonymous (anonymous@undisclosed.example.com) — 2025-03-04T08:59:04+00:00

User Documentation Ispirer Capabilities - Oracle Migration Pricing Oracle RETURN (in function) to HiRDB Return in function changed to the SET RETURNVAL. Oracle: RETURN expr; HiRDB: SET RETURNVAL = expr;

Oracle RETURN（in procedure） to HiRDB

Anonymous (anonymous@undisclosed.example.com) — 2025-03-04T08:59:04+00:00

User Documentation Ispirer Capabilities - Oracle Migration Pricing Oracle RETURN（in procedure） to HiRDB Return in procedure converted to LEAVE. Oracle: RETURN ; HiRDB: label: BEGIN ・・・・・ [BEGIN]・・・・・・ LEAVE label; [END]・・・・・・ END EXAMPLE: Oracle: CREATE PROCEDURE sp_retn1 (var float) as sText float; BEGIN sText :=1; return; END ;

Oracle %ROWTYPE for cursor declaration to HiRDB

Anonymous (anonymous@undisclosed.example.com) — 2025-03-04T08:59:04+00:00

User Documentation Ispirer Capabilities - Oracle Migration Pricing Oracle %ROWTYPE for cursor declaration to HiRDB Oracle: CREATE OR REPLACE PROCEDURE cur1_proc IS CURSOR cur1 IS SELECT c1,c2 FROM t4; cur1_rec cur1%ROWTYPE; BEGIN OPEN cur1; …

Oracle %ROWTYPE in Create Table DDL to HiRDB

Anonymous (anonymous@undisclosed.example.com) — 2025-03-04T08:59:04+00:00

User Documentation Ispirer Capabilities - Oracle Migration Pricing Oracle %ROWTYPE in Create Table DDL to HiRDB Get Column name and data type information from Table Create DDL files. And set each getting information to 'DECLARE　variable_name　data_type' Oracle: CREATE TABLE type_tb ( num_col1 FLOAT, ts_col TIMESTAMP ); DECLARE credit float; type_tb1 type_tb%ROWTYPE; BEGIN credit := 3; END;

Oracle %ROWTYPE not in Create Table DDL to HiRDB

Anonymous (anonymous@undisclosed.example.com) — 2025-03-04T08:59:04+00:00

User Documentation Ispirer Capabilities - Oracle Migration Pricing Oracle %ROWTYPE not in Create Table DDL to HiRDB Add message “/* Could not find CREATE TABLE DDL for type_tb2%ROWTYPE */”. Oracle: CREATE TABLE type_tb ( num_col1 FLOAT, ts_col TIMESTAMP ); DECLARE credit float; type_tb2_t type_tb2%ROWTYPE; BEGIN credit := 3; END;

Oracle SQL%FOUND = TRUE to HiRDB

Anonymous (anonymous@undisclosed.example.com) — 2025-03-04T08:59:04+00:00

User Documentation Ispirer Capabilities - Oracle Migration Pricing Oracle SQL%FOUND = TRUE to HiRDB Change SQL%FOUND = TRUE to its equivalent in HiRDB. Oracle: SQL%FOUND = TRUE HiRDB: SQLCODE<>100

Oracle SQL%FOUND to HiRDB

Anonymous (anonymous@undisclosed.example.com) — 2025-03-04T08:59:04+00:00

User Documentation Ispirer Capabilities - Oracle Migration Pricing Oracle SQL%FOUND to HiRDB Oracle SQL%FOUND changed to its equivalent in HiRDB. Oracle: IF SQL%FOUND then exit; end if; HiRDB: IF SQLCODE<>100 then leave; end if;

Oracle SQL%NOTFOUND = TRUE to HiRDB

Anonymous (anonymous@undisclosed.example.com) — 2025-03-04T08:59:04+00:00

User Documentation Ispirer Capabilities - Oracle Migration Pricing Oracle SQL%NOTFOUND = TRUE to HiRDB Change Oracle SQL%NOTFOUND = TRUE to its equivalent. Oracle: SQL%NOTFOUND = TRUE HiRDB: SQLCODE=100

Oracle SQL%NOTFOUND to HiRDB

Anonymous (anonymous@undisclosed.example.com) — 2025-03-04T08:59:04+00:00

User Documentation Ispirer Capabilities - Oracle Migration Pricing Oracle SQL%NOTFOUND to HiRDB Oracle SQL%NOTFOUND changed to its equivalent in HiRDB. Oracle: IF SQL%NOTFOUND then exit; end if; HiRDB: IF SQLCODE=100 then leave; end if

Oracle SQL%ROWCOUNT to HiRDB

Anonymous (anonymous@undisclosed.example.com) — 2025-03-04T08:59:04+00:00

User Documentation Ispirer Capabilities - Oracle Migration Pricing Oracle SQL%ROWCOUNT to HiRDB Oracle SQL%ROWCOUNT changed to its equivalent in HiRDB. Oracle: SQL%ROWCOUNT HiRDB: SQLCOUNT

Oracle SQLCODE (in exception handler) to HiRDB

Anonymous (anonymous@undisclosed.example.com) — 2025-03-04T08:59:04+00:00

User Documentation Ispirer Capabilities - Oracle Migration Pricing Oracle SQLCODE (in exception handler) to HiRDB If using “SQLCODE” in exception handler ,replace “SQLCODE” to “SQLCODE_OF_LAST_CONDITION”. Oracle: SQLCODE HiRDB: SQLCODE_OF_LAST_CONDITION

Oracle SQLCODE to HiRDB

Anonymous (anonymous@undisclosed.example.com) — 2025-03-04T08:59:04+00:00

User Documentation Ispirer Capabilities - Oracle Migration Pricing Oracle SQLCODE to HiRDB If using “SQLCODE” out of exception handler, conversion is not needed. Oracle: SQLCODE HiRDB: SQLCODE

Oracle SQLERRM (in exception handler) to HiRDB

Anonymous (anonymous@undisclosed.example.com) — 2025-03-04T08:59:04+00:00

User Documentation Ispirer Capabilities - Oracle Migration Pricing Oracle SQLERRM (in exception handler) to HiRDB If using “SQLERRM” in exception handler, replace “SQLERRM” to “SQLERRM_OF_LAST_CONDITION”. If using “SQLERRM” out of exception handler, And add warning message “Could not convert

Oracle %TYPE in Create Table DDL to HiRDB

Anonymous (anonymous@undisclosed.example.com) — 2025-03-04T08:59:04+00:00

User Documentation Ispirer Capabilities - Oracle Migration Pricing Oracle %TYPE in Create Table DDL to HiRDB Get Column name and data type information from Table Create DDL files. And set getting information to 'DECLARE variable_name data_type' Oracle: CREATE TABLE type_tb ( num_col1 FLOAT, ts_col TIMESTAMP ); DECLARE credit float; debit credit%TYPE; debit2 type_tb.ts_col%TYPE; BEGIN credit := 3; END;

Oracle %TYPE not in Create Table DDL to HiRDB

Anonymous (anonymous@undisclosed.example.com) — 2025-03-04T08:59:04+00:00

User Documentation Ispirer Capabilities - Oracle Migration Pricing Oracle %TYPE not in Create Table DDL to HiRDB Add message “/* Could not find CREATE TABLE DDL for 'type_tb2.col%TYPE' */”. Oracle: CREATE TABLE type_tb ( num_col1 FLOAT, ts_col TIMESTAMP ); DECLARE credit float; debit credit%TYPE; var1 type_tb2.col%TYPE; BEGIN credit := 3; END;

Oracle Variable Declaration to HiRDB

Anonymous (anonymous@undisclosed.example.com) — 2025-03-04T08:59:04+00:00

User Documentation Ispirer Capabilities - Oracle Migration Pricing Oracle Variable Declaration to HiRDB 'NOT NULL' is not supported on HiRDB.So if 'NOT NULL' is specified , remove 'NOT NULL'. And ':=' fix 'DEFAULT'. Oracle: variable_name data_type [NOT NULL] [{:=|DEFAULT} default_value]; HiRDB: DECLARE variable_name　data_type [DEFAULT default_value] ;

Oracle WHILE LOOP to HiRDB

Anonymous (anonymous@undisclosed.example.com) — 2025-03-04T08:59:04+00:00

User Documentation Ispirer Capabilities - Oracle Migration Pricing Oracle WHILE LOOP to HiRDB Replace “<>” to “label_name:” . Replace after WHILE condition “LOOP” to “DO” . Replace “END LOOP” to “END WHILE” . Oracle: [<>] WHILE condition LOOP statement; [statement;]… END LOOP [label_name];