IN with more than 9 element raise oracle.r2dbc.impl.OracleR2dbcExceptions$OracleR2dbcException: [17110] [99999] Warning:

[larousso]

Hi,

I got an oracle.r2dbc.impl.OracleR2dbcExceptions$OracleR2dbcException: [17110] [99999] Warning: ... when I ran query with more than 9 element in a IN statement. There is no problems with JDBC so I don't think this is a database issue. Is there a specific option to turn on or something to do to make it work ?

Thanks

[Michael-A-McMahon]

Hi @larousso. Can you share some code that would reproduce the issue?

[larousso]

Hi, I can't share the query but it is a query that return a lot of in XML. I have done some test and it seems that the error depends on the size of the query

[Michael-A-McMahon]

In order to fix the issue, I'll need to understand how to recreate the issue. Rather than provide the exact query, could you provide a new query that recreates the issue?

[Michael-A-McMahon]

Hi @larousso. Sorry for the lack of progress on this, I let this issue sit for too long.

I'm just now noting that the error code, 17110, indicates a warning was raised by the database. So the SQL is not actually failing; Rather, the database is executing it, but it is also trying to warn us about something.

Another issue has cropped up about warnings recently: #93

You are more than welcome to join the discussion there, if you'd like to.

[larousso]

Nice, i will try to filter warnings

[Michael-A-McMahon]

Should be fixed when #98 merges, so I'll close this issue. Thanks again for the discussion!