[TYPO3-dev] TYPO3/Extbase 6.2 and MySQL Calling Stored Procedures

[g4-lisz at tonarchiv.ch]

Hi Developers

I wonder if there's a way with 6.2 to make calls to stored procedures
working.

I need this for my website to trigger some complex database
synchronisation (there's one CMS for administrative purposes only, which
needs some data from the public site, which shares the same LAMP).
Of course there are workarounds like writing queries in the repository
of my own... But just triggering a SP would be much nicer.

Last time (6.1) I tested this, it did not work in extbase repository
context:
There's an issue because the mysqli statement->results are not fully
emptied after a call, and so the next DB query leads to an error.
After calling a SP, there should be something like

    while ($stmt->more_results() && $stmt->next_result());

Or the mysli handler has to be closed and reopened for next use.

Maybe there is some hook where I could trigger this kind of result emptying?

Any help would be much appreciated!

Cheers,
Till