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

[BUG] Upsert Mode errors with large CLOB columns #116

Open
vijayanandnandam opened this issue Feb 22, 2022 · 2 comments
Open

[BUG] Upsert Mode errors with large CLOB columns #116

vijayanandnandam opened this issue Feb 22, 2022 · 2 comments

Comments

@vijayanandnandam
Copy link

vijayanandnandam commented Feb 22, 2022 •
edited

I am using Oracle as target database for sink connector and facing this error when trying to insert a large data into CLOB column.

Error Msg = ORA-01461: can bind a LONG value only for insert into a LONG column

The column data size > 4000 characters and triggers when merge statement results in UPDATE of an existing row.

Possible due to this bug
https://support.oracle.com/epmos/faces/DocumentDisplay?_afrLoop=203330692365177&parent=EXTERNAL_SEARCH&sourceId=PROBLEM&id=1620109.1&_afrWindowMode=0&_adf.ctrl-state=syn80pubt_4

Thanks.
@vijayanandnandam
Copy link
Author

Document 1620109.1.pdf
Document for reference

@vijayanandnandam vijayanandnandam changed the title Upsert Mode errors with large CLOB columns [BUG] Upsert Mode errors with large CLOB columns Feb 23, 2022
@vijayanandnandam
Copy link
Author

I would appreciate any update on this..
This bug pretty much makes the connector unusable for Oracle db.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
None yet
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
1 participant
@vijayanandnandam