[SAP HANA] Exception handling when executing a DDL statement in a procedure

[former_member1059035]

Hi all,

Please consider the following simple HANA stored procedure:

I want to create a procedure to execute this DDL statement in dynamic SQL.

ALTER SYSTEM DISCONNECT SESSION 'XXXXXX';<br>

If the session is running, it will terminate normally, but if the session terminates while the procedure is running, the error handling will not be handled correctly, and the process will drop in the middle when it is determined to be exception handling.

Is it possible to get correct error handling and have the procedure terminate normally instead of with an error?

I can't find any tips on exception handling for DDL statements and would like to know about it.

Thanks,