Subject | Execute SQL scrip (few sql statements) in one step in SP |
---|---|
Author | |
Post date | 2014-06-21T06:36:31Z |
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...