Ispirer Website Ispirer Capabilities - Oracle Migration Free Trial

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;

HiRDB:

CREATE TABLE type_tb 
(
   num_col1    FLOAT,
   ts_col      TIMESTAMP
);

CREATE PROCEDURE sp_types()
BEGIN
   DECLARE credit FLOAT;
   DECLARE debit FLOAT;
   DECLARE var1 type_tb2.col%TYPE;
   /* Could not find CREATE TABLE DDL for 'type_tb2.col%TYPE' */
   SET credit = 3;
END;
END_PROC

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