Can anybody provide the best approach for below mentioned situation?
We need to create a JDBC Notification in package A, but eventually need to pass the values received from JDBC notification to package B.
Approach 1) Trigger and a service should be created in package A and service at package A should call package B service and pass values to service at package B.
Approach 2) Trigger should be created at package A but service that will be invoked by this trigger should directly be created at package B.
It will be really helpful if you can advise reason for best approach as well.
Thanks in advance.