Skip to Main Content

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

FOEX Tree Grid getting started - missing right parenthesis error

Jernej Koren11 hours ago — edited 11 hours ago

Hello, I'm testing FOEX Tree Grid in Apex, with some basic departments table using this hierarchichal SQL query:

select dep_id,
parent_dep_id,
short_description
from departments
connect by prior dep_id = parent_dep_id
start with dep_id = 58;

I've mapped the needed columns and left other settings to default:

I get the ‘missing right parenthesis error’ on page load - Any idea why?

Comments
Post Details
Added 11 hours ago
1 comment
25 views