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.

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