|Subject||Execute SQL scrip (few sql statements) in one step in SP|
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...