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