Error: Failed to generate XML Schema Definition for the SQL query

Summary

Error: Failed to generate XML Schema Definition for the SQL query

Content

I get the following error while using Oracle Database Connection inside Integration: Failed to generate XML Schema Definition for the SQL query. Please check the SQL Query entered. Refer Oracle documentation for further information. Query has 2 parameters:

select * from (select row_number() over (order by username) rnum, a.* from sch.accounts a) where rnum between #start and #end order by rnum

but this one is working fine:

select * from (select row_number() over (order by username) rnum, a.* from sch.accounts a) where rnum >= #start and rnum < #end order by rnum