ORA-00604 hiding ORA-01013 when cancelling task

Hi,

To my understanding issues in this repo are a way to provide feedback on unexpected behavior in the Oracle.EntityFrameworkCore implementation, as it is not open source or has its own repository. If this is not the case please let me know.

This is related to an issue reported in the Oracle forum last year: Forum Entry
I am now facing the same, I am using:
Oracle.EntityFrameworkCore Version 10.23.26200
.net 10
Oracle db 19c (EF core with OracleSQLCompatibility.DatabaseVersion19)

When cancelling a long running Query via the CancellationToken given to ToListAsync(cancellationToken) an OracleException with ORA-00604 is thrown. The message text of the exception states that the actual Error encapsulated is ORA-01013. However the OracleException.InnerException is null.

It would be very helpful if the Oracle.EntityFrameworkCore would throw an OperationCanceledException or at least have an OracleException as InnerException that has ErrorCode 1013 so we can react properly, since cancelling long running queries is an expected behavior in our app while other errors during fetching data are not. Therefore it would be good if we can have a well defined distinction.

Thank you for your support.
BR Markus

Start by reproducing cancellation through ToListAsync(cancellationToken) with Oracle.EntityFrameworkCore 10.23.26200, .NET 10, and Oracle Database 19c. Inspect how the provider surfaces ORA-00604 and ORA-01013; done means cancellation is distinguishable as OperationCanceledException or exposes an OracleException with error code 1013.