Hi,
I got a workbench published to FME server as an Jobsubmitter service now i want to call or execute this work space from an oracle trigger which triggers after an update to that table.
Below is my function would be called from the oracle table trigger but i can't see the workspace execution has started or completed.
I got proper UTL_HTTP access to the user and no errors while executing the function.
Can anyone shed some light what is the proper way to achieve this?
**********************************************************************************************************
CREATE OR REPLACE FUNCTION DBUSER.FME_CALL RETURN BOOLEAN
AS
message varchar2(20);
req utl_http.req;
BEGIN
message := '99999';
-- Call the workspace
req := utl_http.begin_request('http://FMEServer/fmejobsubmitter/training/xml2dwg.fmw','POST'); utl_http.set_header(req, 'User-Agent', 'Mozilla/4.0');
utl_http.set_header(req,'Content-Type','TEXT/HTML');
utl_http.set_header(req, 'content-length', length(message));
utl_http.write_text(req, message);
utl_http.end_request(req); return true;
END;
/
**********************************************************************************************************
Thanks,
reachmj
