CODEWITHSUNDEEP
oracle-databaseoracle10goracleforms
StandForTheRight
StandForTheRight

Reputation: 135

Oracle Forms 10g - 'NULLS' is not accepted

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

Upvotes: 0

Views: 290

Answers (2)

user5683823
user5683823

Reputation:

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)

Upvotes: 1

sers
sers

Reputation: 3659

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.

Upvotes: 1

Related Questions