Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

[ORACLE] Export of data created as SYS.DATA causes migration failure #1571

Open
chetank-yb opened this issue Dec 12, 2022 · 0 comments
Open

Comments

@chetank-yb
Copy link

Schema Used

CREATE TYPE pet_t IS OBJECT ( 
   tag_no   INTEGER 
  ,NAME     VARCHAR2 (60) 
  ,breed    VARCHAR2 (100) 
);

CREATE TYPE zoo_t IS TABLE OF pet_t;

CREATE TABLE wild_side (  
   ID NUMBER PRIMARY KEY  
 , DATA SYS.ANYDATA  
); 

DECLARE  
   my_cat    pet_t  
          := pet_t (50, 'Sister', 'Siamese');  
   my_bird   pet_t  
      := pet_t (100  
               ,'Mercury'  
               ,'African Grey Parrot'  
               );  
   my_pets   zoo_t := zoo_t (my_cat, my_bird);  
BEGIN  
   INSERT INTO wild_side  
        VALUES (1  
               ,SYS.ANYDATA.convertnumber  
                                         (5));  
  
   INSERT INTO wild_side  
        VALUES (3  
               ,SYS.ANYDATA.convertvarchar2  
                      ('Pretty crazy stuff!'));  
  
   INSERT INTO wild_side  
        VALUES (5  
               ,SYS.ANYDATA.convertdate  
                                    (SYSDATE));  
  
   INSERT INTO wild_side  
        VALUES (2  
               ,SYS.ANYDATA.convertobject  
                                    (my_bird));  
  
   INSERT INTO wild_side  
        VALUES (7  
               ,SYS.ANYDATA.convertcollection  
                                    (my_pets));  
  
   COMMIT;  
END; 

Expected : The table wild_side must be migrated
Actual : The table wild_side is not migrated

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

2 participants