Http Request for DB update

[Former Member]

Hi All,

I have requirement to send request (by any means like http, soap, web service) whenever any action (insert, update, delete) happens in database.

I have read that we can use trigger which is automatically executed on any insert, update, delete on database and can send email for notification.

Can we send http or soap request using trigger?

Is it possible? If Yes, How?

Please guide me.

Regards,

Manisha

[fidel_vales]

Hi,

Unfortunatelly, triggers are not supported in SAP environment. For more details see SAP Note:

105047: Support for Oracle functions in the SAP environment
 57. Trigger                                                                                
o  Used implicitly by SAP in the BW environment (/BI0/05*, see Note   
        449891)                                                                                
o  Logon Trigger can be used in accordance with Note 712777.                                                                                
o  Otherwise, it cannot be used                                                                                
o  You cannot use trigger-based real-time replication either.