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

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