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;
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