Error handling between two HANA SQL stored procedures

[former_member201560]

Hi all,

I am calling stored procedure(B) inside one stored procedure(A). In the stored procedure(B), I am raising user defined error message using SIGNAL statement. I am not able to see the error when i execute the stored procedure(A). But, when I execute the stored procedure(B), I am getting the user defined error message successfully.

Please help me out how should I get the error message When I execute the stored procedure (A) ? The error message should pass from stored procedure B to A.

Regards,

Yogesh

[former_member182302 · Accepted solution]

pass the value from error_message variable to your local variable and pass this variable as a the output parameter which can be received by your stored procedure A.

Regards,

Krishna Tangudu

[former_member201560 · Accepted solution]

Thanks Krishna,

I am also thinking on the same line, thought of posting the question in SCN to get the best approach to handle this scenario.

Thanks for your reply.

Regards,

Yogesh

[former_member182302 · Accepted solution]

welcome Yogesh.

I assume you know the syntax of how to send an output parameter from procedure B to A. Let me know if you face any issues.

Regards,

Krishna Tangudu