I'm am looking into the possibility to call a DB2 stored procedure from Oracle as a asynchronous or deferred transaction.
I need this because users don't have to wait for the transaction to complete.
One solution is to create a table to store the data in, which is needed to call the db2-procedure, and then create a job to process this.
The second solution would be without a table by making a call to the dbms_defer - package, that on it's turn, makes a call to the db2 stored procedure.
Anyone already tried something like this?
Or are there better alternatives/solutions?