ORDS, SODA & JSON in the Database

I created a Resource Template called "getChartData".
The GET (Type - Media Resource) is defined as:

select 'text/x-apex-html', xmlquery( f_getchartdata returning content)
from dual

(getchartdata is a procedure spitting out XML). If I run this from straight from the browser, it returns the correct XML structure.
(Also when I replace that query with just select 'text/x-apex-html', f_getchartdata from dual it works ok).

Now I want that output to be the input of an AnyChart chart. So in the Region Source of the chart I replace
XMLFile=#HOST#apex_util.flash?p=&APP_ID.:&FLOW_PAGE_ID.:&APP_SESSION.:FLOW_FLASH_CHART5_R#REGION_ID#"
with
XMLFile=http://localhost:7777/apex/getChartData (which should refer to the ResourceTemplate)

but alas, that doesn't seem to work.

Because I am not quite sure if XMLCallDate is added as a parameter, I created another Template with that parameter : getChartData?XMLCallDate={dummy}

Any ideas, clues? Or is this - for one reason or another - never going to work?

(Because it is related to the APEX Listener and APEX itself I'll cross post it - and will make a cross reference, so it doesn't matter where you post your answer, as long as you do ;-) )

Thread in APEX Forum : http://forums.oracle.com/forums/thread.jspa?threadID=2186909


TIA
Roel