Oracle Forms 10g - 'NULLS' is not accepted

0
votes

Oracle Forms 10g - 'NULLS' is not accepted.

In program unit(PL/SQL Code) I use NULLS FIRST and its throwing error.

Encountered the symbol NULLS

select line_id 
from oe_order_lines_all 
where rownum <5 
order by line_id NULLS FIRST;

kindly help

2
oracleoracle10goracleforms
Share your PLSQL program. - XING
select line_id from oe_order_lines_all where rownum <5 order by line_id NULLS FIRST; It works in SQL developer but in oracle forms - compile error - StandForTheRight

2 Answers

1
votes

I am not familiar with forms, but a simple workaround (if it works) is to modify the order by clause. For example, assuming the line id's are positive, or at least non-negative, you could 

order by nvl(line_id, -1)
1
votes

The flavour of PL/SQL and SQL used in Forms is different and somewhat older than the one available in the database. Being able to run code on the database does not mean it will run without changes in Forms. Analytic functions is an example of a newer SQL feature which is missing in Forms. But you can always put your code into a PL/SQL package in the database and call it from your forms code.