Toad World® Forums

Sql parser bug in FETCH FIRST part

SQL Optimitzer 9.3 x64 on Oracl 12.1 client against 12.1 DB.
If we use query like:

select * from orders where order_id>:N1 order by order_id desc FETCH FIRST :N2 ROWS ONLY;

SQL Optimizer recognize first parameter but missed second one (no pleace to define) so it ends with error in execution.
Brg
Damir

Thanks to report this error. Our parser seems doesn't expect a parameter after FETCH. It is our bug and we will create a case to follow it.

Thanks again.
Tony Ng