Oracle Forms (MOSC)

MOSC Banner

ORDER SIBLINGS not working in Forms

edited Nov 21, 2013 3:38AM in Oracle Forms (MOSC) 1 commentAnswered
I'm using Forms 9.0.4.0.19 (DS 10g).
Hierarchial query:

select level,empno, ename from emp
connect by prior
empno = mgr
start with mgr is null
order siblings by ename


is working fine in SQL prompt, and it's working in Forms Developer tree control,
List of values, Record groups ...


Problem is in PL/SQL Program Units and Trigger:

cursor some_tree  is select level,empno, ename from emp
connect by prior
empno = mgr
start with mgr is null
order siblings by ename

This will produce:

Error 103 at line x, column y
 Encountered the simbol "SIBLINGS" when expecting one of the following ...


Seems that Database PL/SQL engine supports clause ORDER SIBLINGS BY while Forms Builder does not.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center