I am new to writing stored procedures and wondering if it's possible to call a Oralce' stored procedure from DB2 stored procedure.
I have a scenario where a trigger on a DB2 table will invoke a DB2 stored procedure. And further this stored procedure have to call to connect with Oracle DB to do some certain operation (a stored procedure).
Is my understanding is right, and can Oracle's stored procedure can be called through DB Link?
Edit: The version of DB2 is 9.7 and my platform is AIX 6.