When I a create a new global page and add a tree region on it then when I run the application it comes up with a error ORA-20001: Query must begin with SELECT or WITH.
I have used the emp table to test.
Does anyone know about this issue? Is there a problem with trees on global pages in apex4.2?
Thanks for any comments
When creating a Global Page, the page number should be 0,
The problem is with procedure wwv_flow_tree_region.READ_META_DATA, in the condition
AND PAGE_ID IN (G_PAGE_ID,0))
it should retrieve records for the current page and the Global Page (Not page 0), or the page ID for the Global Page should be always 0
Edited by: salwerr on Jan 17, 2013 6:44 AM
have you unwrapped our packages? You are such a bad guy! ;-)
@Rob: That bug is fixed in our 4.2.1 patch set, I assume you are still on 4.2.0.
My Blog: http://www.inside-oracle-apex.com
APEX Plug-Ins: http://apex.oracle.com/plugins