How to access OWBSYS.wb_rt_script_util.show_service() through database link
Hi.
Platform: Windows 2008 server with 11g EE db and OWB 11g.
I have the following problem; I want to make a simple "traffic light" in Oracle APEX where I query the OWB function OWBSYS.wb_rt_script_util.show_service() from my APEX schema through a database link to the OWBSYS-schema in the OWB target database. Green light if control service is up, red light if not.
Calling the function locally in the OWB target database works fine, but trying to query it over a database link from my APEX database results in the following:
ORA-02064: distributed operation not supported
ORA-06512: ved "SYS.DBMS_LOCK", line 250
ORA-06512: ved "OWBSYS.SERVICE_AVAILABLE", line 8
ORA-06512: ved "OWBSYS.WB_RT_SCRIPT_UTIL", line 1021
Seems like there is some kind of update/insert going on behind the scenes on the service_available thing that prevents me from calling it through a database link....
Anyone done anthing like this with any luck?
(I've tried fiddling around with PRAGMA AUTONOMOUS_TRANSACTION on this call, but that didn't work either...)
Regards,
-Haakon-