How to CALL stored procedure in mysql on from cms module

[cve]

Hi,
I have this code:

Code: Select all

$db = cmsms()->GetDb();
$q = 'CALL ADD_CHILD("Kategorie", "Somethink");';
    $dbr = $db->Execute($q);
    if (!$dbr)
        echo('Error executing query: ' . $db->sql . '<br/>' . $db->ErrorMsg());

And result is:

Code: Select all

Error executing query: CALL ADD_CHILD("Kategorie", "Somethink");
PROCEDURE cveionic_cmsms.ADD_CHILD can't return a result set in the given context 

How can I solve that???