yugabyte/yb-voyager

[Oracle] BULK COLLECT syntax is not migrated properly

shubham-yb opened this issue · 0 comments

If we have an Oracle DDL which has a BULK COLLECT clause, since this is not supported in PG/YB, it errors out during import.

Since YB / PG doesn't have a direct equivalent of Oracle's BULK COLLECT, we can achieve similar functionality using arrays or using cursors with array aggregation. More to be explored on this.