OraFAQ Forum: Forms » ORDER SIBLINGS not working in Forms

Home » Developer & Programmer » Forms » ORDER SIBLINGS not working in Forms (Oracle forms 10G, windows XP)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

ORDER SIBLINGS not working in Forms [message #485061]

Sun, 05 December 2010 23:24

wency
Messages: 450
Registered: April 2006
Location: Philippines

Senior Member

This code run fine in Toad BUT giving me error in forms.

SELECT 
       LEVEL                           LOC_NAME,
       LOCATION_NAME                   LOC_ID,
       LOCATION_ID                     HLOC_ID,
       HEAD_LOC_ID MUDRA
  FROM AS_LOCATION_HDR
CONNECT BY PRIOR LOCATION_ID = HEAD_LOC_ID
START WITH HEAD_LOC_ID is null
ORDER SIBLINGS BY LOC_ID

The error is:

"Encountered sysbol "SIBLINGS" when expecting one of the following:
by
The symbol "by inserted before the "SIBLINGS" to continue.

Is the SIBLINGS keyword not acepted in forms? What would be the alternative?

[Updated on: Sun, 05 December 2010 23:27]

Report message to a moderator

Re: ORDER SIBLINGS not working in Forms [message #485069 is a reply to message #485061]

Mon, 06 December 2010 00:56

Littlefoot
Messages: 21818
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

It seems that Forms' PL/SQL engine doesn't understand it (i.e. is "older" than database's PL/SQL).

You could try to create a view (in the database) and use it within the form.

Report message to a moderator

Re: ORDER SIBLINGS not working in Forms [message #485078 is a reply to message #485069]

Mon, 06 December 2010 01:42

wency
Messages: 450
Registered: April 2006
Location: Philippines

Senior Member

Thanks Littlefoot. Smile

Report message to a moderator

Previous Topic:	Calling Report Designer 5.0u (MRD) from oracle form builder 6i
Next Topic:	how to change list item value programmatically

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Sep 19 13:51:50 CDT 2024