You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

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?

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!