How do I set the flag CLIENT_MULTI_STATEMENTS
for calling multiple stored procedures in a single stored procedure?
I have 30 stored procedures I would like to execute with a button click to process user data. It seems that creating a single procedure to execute the 30 others would be easiest but this triggers a syntax error.
Executing one stored procedure in a stored procedure works just fine, adding even one more creates an error.
My research has indicated by setting the CLIENT_MULTI_STATEMENTS
flag I can execute multiple procedures but there is little documentation on how to do this within a CMS like Joomla.
I am working with Joomla 3 / mysql 5.7 / mariadb.
Do I have to modify core code? Or is there a way to set the flag externally?
The procedures are called in order as seen below, the first procedure always executes without issue. I have checked the mariadb documentation and mysql and tried every iteration of the proper syntax I could think of, which is why I think it is a flag issue.
By default, mysql will not allow execution of multiple statements in this version, as I understand it. Which is why I would like to figure out how to set the flags as referenced in the documentation.
CALL joomla3.Answers_to_Translated_RTN1();
CALL joomla3.Answers_to_Translated_RTN2();
CALL joomla3.UC_to_Results_RTN3();
...
MySQL said: #1064 - You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'CALL joomla3.Answers_to_Translated_RTN2(); CALL joomla3.UC_to_Results_RTN3(); ' at line 2