Skip to main content
Question

How to execute a published work-space from Oracle


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

4 replies

itay
Supporter
Forum|alt.badge.img+16
  • Supporter
  • May 2, 2017

Possibly this artikel can shed some light on the procedure necessary:

https://knowledge.safe.com/articles/1098/single-edits-oracle-push-data-from-the-database-to.html


  • Author
  • May 2, 2017
itay wrote:

Possibly this artikel can shed some light on the procedure necessary:

https://knowledge.safe.com/articles/1098/single-edits-oracle-push-data-from-the-database-to.html

Thanks for this link but i got my logic from there itself..May be i need to look into the authentication while calling the web service i guess.

 

 


itay
Supporter
Forum|alt.badge.img+16
  • Supporter
  • May 2, 2017
reachmj wrote:
Thanks for this link but i got my logic from there itself..May be i need to look into the authentication while calling the web service i guess.

 

 

kinda suspected that....yes that would be the first thing I would check

 

 


david_r
Evangelist
  • May 2, 2017

Check the FME Server log files, if the REST call was received there should be a trace in the fmeserver.log.

You are correct that authentication is necessary.


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings