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.

Sign up for GitHub

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

Jump to bottom

[Oracle] BULK COLLECT syntax is not migrated properly #1539

Open
shubham-yb opened this issue Jun 5, 2024 · 0 comments
Open

[Oracle] BULK COLLECT syntax is not migrated properly #1539

shubham-yb opened this issue Jun 5, 2024 · 0 comments
Labels
area/voyager kind/enhancement priority/medium triage Needs to be triaged

Comments

@shubham-yb
Copy link
Contributor

shubham-yb commented Jun 5, 2024 •
edited by yugabyte-ci
Loading

Jira Link: DB-13449
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.
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
area/voyager kind/enhancement priority/medium triage Needs to be triaged
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
3 participants
@saratkumar-yb @yugabyte-ci @shubham-yb