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