I am trying to write application data to Oracle DB.
I am attempting to insert a comment of nearly 4,000 bytes, and the column Comment in Oracle DB is defined as type CLOB.
When I try to assign an Axon Ivy variable String aiComment to the Comment column in Oracle DB using DatabaseActivity, I get the following error:
ORA-01704: string literal too long
How can I fix this?
Should I implement the DB connection and SQL write process separately in a Java file?
Or is there a way to use bind variables with DatabaseActivity?
Environment:
AxonIvy v12.0.12
Oracle DB 19c
