search

oracle / oracle-r2dbc

R2DBC Driver for Oracle Database
https://oracle.com
Other
194 stars 40 forks source link

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

Closed larousso closed 1 year ago

larousso commented 2 years ago

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 commented 2 years ago

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

larousso commented 2 years ago

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 commented 2 years ago

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 commented 1 year ago

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 commented 1 year ago

Nice, i will try to filter warnings

Michael-A-McMahon commented 1 year ago

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