Ispirer Website
Ispirer Capabilities - Oracle Migration
Free Trial
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;
HiRDB:
CREATE TABLE type_tb ( num_col1 FLOAT, ts_col TIMESTAMP ); CREATE PROCEDURE sp_rowtype() BEGIN DECLARE credit FLOAT; type_tb2_t type_tb2%ROWTYPE; /* Could not find CREATE TABLE DDL for type_tb2%ROWTYPE */ SET credit = 3; END; END_PROC