This content has been marked as final. Show 3 replies
Hi there, did you get this issue when using apex.oracle.com's free workspace or on a separate stand-alone installation with Oracle DB standard edition? I too have noticed this and it effectively puts a full stop to any development on my part with APEX since I cannot expose useful web services this way unfortunately :( I'm not sure if this is a limitation of the online demo version of apex.oracle.com since if it is present in the main APEX installation, it is quite a bad restriction. As for a workaround, I'm looking at trying to send the different fields' values merged into a single collection object separated with some delimiter perhaps so you get a JSON object with items containing collections.
I get a restful webservice defined and it return results when I click test button. But in the result returned, it only has two fields but not all fields I defined.Any Ideas?
cyear || '-' || cmonth month,
from dbmon_service_overview_his a inner join dbmon_service_avil b on(a.service_id = b.service_id)
where (cyear || '-' || cmonth) = :c_month
The RESTful services are part of Apexlistener. Please post
<li>JEE Container used / Standalone</li>
As far as I can see both ApexListner 1.1.4 and 2.0 EA, both on Glassfish, are working fine for me. I get well formed and all columns in the query for my RESTful services.