Value limit in a variable when creating a secondary charge
Summary:
To provide some context, we use the secondary charge creation action (fleet management) by selecting a shipment group, but for some, this doesn't work, with no direct explanation. In the logs, we noticed that one of the calculated variables, containing a SELECT query on the s_ship_unit table, lists 80,500 s_ship_unit values in batches of 100. The error appearing in the logs is as follows:
java.sql.SQLSyntaxErrorException: ORA-01745: invalid host/bind variable name
https://docs.oracle.com/error-help/db/ora-01745/
We know this is a computer limit on the number of digits a message can contain (a bit like the limit in Excel of 65536 lines), but do you have a possible workaround, and have you ever encountered a similar error from another customer?