Issue with Triggers in SAP HANA Cloud – Alternative Solutions for Running Calculations

[seyfeddine]

Hello SAP HANA experts,

We are currently migrating our database from SQL Server (SSMS) to SAP HANA Cloud, and we have encountered a blocking issue with triggers.

Problem Statement:

In SQL Server, we use triggers to launch calculations that involve the creation and deletion of temporary tables. However, in SAP HANA Cloud, we receive the following error when trying to execute similar logic within a trigger:

Not permitted statement: cannot use other than DML statements in trigger

To work around this, we attempted to call a stored procedure from the trigger, but we encountered the same restriction.

Questions:

1. Is there any way to execute complex calculations (including temporary table creation and deletion) within a trigger in SAP HANA Cloud?
2. If not, what are the best alternative approaches to achieve the same functionality in SAP HANA Cloud?

Any guidance or best practices would be greatly appreciated!

Thanks in advance.