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