Subject Execute SQL scrip (few sql statements) in one step in SP
Author

Hello,


I have an idea to transfer some client side code to Firebird SP and speed up and secure those work.


My client side application procedure is collect some SQL statements from 1 to n depent of situation and made some unique SQL statement divided by ; and execute it from app.


Now I need to transfer that logic to Firebird SP, but I have one limitation EXECUTE STATEMENT will execute only one SQL statement it not support SQL scripts (more SQL statements divided by ; for example)


Is there any idea how ti solve this scenario, thanks in advance...