Hi guys, I've bumped into a nasty snag using Modeler 2.5.6 that's related to Oracle database limitations. I've got an XPath query that retrieves over 1000 records, and its triggering an "SQL State: 42000, Error Code: 1795" error. Apparently, I've run into a hard limit on the number of records allowed within an "IN" clause statement being parsed by Oracle. Now I've found a workaround using some clever list union operations, but I wanted to know: Is this in a support ticket somewhere? Or should I fill one out?
asked
Haytham Bennani
1 answers
0
Fill one out! :)
(seems relatively obscure, small chance that someone else has submitted this)