ORA-01013: User requested cancel of current operation

[Raveendra-Pai]

Description

We are intermittently encountering the following exception while executing a stored procedure using Dapper.Extension with Oracle.ManagedDataAccess:

ORA-01013: User requested cancel of current operation.
https://docs.oracle.com/error-help/db/ora-01013/

Oracle.ManagedDataAccess.Client.OracleException (0x80004005): ORA-01013: User requested cancel of current operation.
   at OracleInternal.ServiceObjects.OracleFailoverMgrImpl.OnError(...)
   at Oracle.ManagedDataAccess.Client.OracleDataReader.Read()
   at Dapper.SqlMapper.QueryRowImpl[T](...)
   at Dapper.SqlMapper.QueryFirstOrDefault[T](...)
   at Dapper.Extensions.BaseDapper`1.QueryFirstOrDefault[TReturn](...)
   at ETalk.DRE2.DataAccess.Common.DapperSqlMapperWrapper.QueryForProcedure[T](...) 

📌 Environment
.NET Version: .Net 10
Oracle.ManagedDataAccess.Core Version: 23.26.0
Dapper.Extension.NetCore Version: 5.4.2
Database: Oracle 19.0.0.0.0

🔍 Observed Behavior
Exception thrown during QueryFirstOrDefault()
Occurs while reading data (OracleDataReader.Read())
Stored procedure execution is being cancelled before completion

Code Snippet throwing Exception:

return _dapper.QueryFirstOrDefault<T>(
    sql: statementName,
    param: parameterObject,
    enableCache: false,
    commandType: CommandType.StoredProcedure,
    commandTimeout: _commandTimeout
);

[ZeeLyn]

Please check if your stored procedure involves database locks.

[Raveendra-Pai]

No, it is simple select query without lock. and this exception is failing immediately even though we set timeout of 60 seconds.
The stored procedure below:
PROCEDURE GET_ENTITY_AND_ACCOUNT ( IDENTIFIER_IN IN VARCHAR2, REFERENCE_TIME_IN IN DATE, RESULT_OUT OUT SYS_REFCURSOR ) AS BEGIN OPEN RESULT_OUT FOR SELECT resource.CUSTOMER_ID, resource.SUBSCRIBER_ID, resource.OPERATOR_ID, resource.RESOURCE_ID, resource.PENDING_STATUS_ID, resource.STATUS_ID, resource.CONFIG_PARAM_A, resource.CONFIG_PARAM_B, resource.CONFIG_MASK, resource.SERVICE_LIST, resource.FEATURE_FLAG, resource.IDENTIFIER, resource.PACKAGE_ID, resource.SERVICE_PROFILE, resource.LOCALE_CODE, account.ACCOUNT_ID, account.CUSTOMER_ACCOUNT_ID FROM RESOURCE_TABLE resource INNER JOIN ACCOUNT_TABLE account ON resource.CUSTOMER_ID = account.CUSTOMER_ID WHERE resource.IDENTIFIER = IDENTIFIER_IN AND resource.START_TIME <= REFERENCE_TIME_IN AND ( resource.END_TIME IS NULL OR resource.END_TIME >= REFERENCE_TIME_IN ); END GET_ENTITY_AND_ACCOUNT;