We've done this (Kick a UC4 job from Oracle), but it wasn't easy. We deployed our solution back in 2012 and its still working fine today.
We have legacy Oracle apps that write job requests to the Appworx table JOB_QUEUE to kick off batch executions. When we replaced Appworx with UC4, we created our own JOB_QUEUE table with a trigger that kicks off the request in UC4, so none of these applications required any modifications. The way we accomplished this is we built a homegrown webapp that uses the Windows CALLAPI to communicate with UC4. The Oracle trigger does a SOAP call to this webapp.
A major flaw of this solution is that if your unit of work needs to rollback, there is no way to rollback the CALLAPI request.
Now UC4 supports RESP API calls that I suspect could solve this problem more gracefully(?)
------------------------------
Pete
------------------------------
Original Message:
Sent: 02-06-2020 03:01 AM
From: Serhat Yucel
Subject: How to start Another UC4 JOB UC4 From PLSQL Code Block?
Hello,
I want to start another UC4 job in PLSQL code block but I do not know how to do that. I would like to explain myselft with example script.
SQL_SET_STATEMENT_TERMINATOR TERM='@';
DECLARE
plsqlVaraible NUMBER(1) := 1';
BEGIN
IF plsqlVaraible = 1 THEN
:SET &ACTOBJ = ACTIVATE_UC_OBJECT(JOBS.ANOTHER_EXAMPLE_JOB)
END IF;
END;@
I can not start another job from plsql code block. How can i do that? I have to start from inside of plsql code, this is must. Can you help me about that?
Thanks.