Question

How to execute a published work-space from Oracle

Forum|Forum|8 years ago
May 2, 2017
4 replies
44 views

reachmj

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

This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.