MYSQLI + Procedure - não executa procedure

[rafaeldorazio]

O codigo que acessa a procedure, não está executando a procedure. Tem como eu fazer algo para ver se o processo está dando erro ?

$sp = mysqli_prepare($conexao, "call sp_insert_update_funcionario(?, ?, ?, ?, ?, ?, ?, ?, ?, ? )");
    
        /* Atribuimos um valor ao '?' */
        mysqli_stmt_bind_param($sp, "i", $fun_codigo);
        mysqli_stmt_bind_param($sp, "s", $fun_usuario);
        mysqli_stmt_bind_param($sp, "s", $fun_senha);
        mysqli_stmt_bind_param($sp, "s", $fun_email);
        mysqli_stmt_bind_param($sp, "s", $fun_nome);
        mysqli_stmt_bind_param($sp, "s", $fun_cpf);
        mysqli_stmt_bind_param($sp, "s", $fun_cnpj);                                
        mysqli_stmt_bind_param($sp, "s", $fun_rg);
        mysqli_stmt_bind_param($sp, "s", $fun_pis);
        mysqli_stmt_bind_param($sp, "s", $fun_sexo);
                                                                        
        
                                    
        /* Executamos o statment */
        mysqli_stmt_execute($sp);
    
        /* Atribuimos os resultados as variaveis */
        mysqli_stmt_bind_result($sp, $msgRetorno);
        
        mysqli_stmt_fetch($sp);

        echo $_GET['callback'].'{"success":"'. $msgRetorno .'"}';
    
        /* Fechamos statement */
        mysqli_stmt_close($sp);

Erro:

Warning: mysqli_stmt_bind_param(): Number of variables doesn't match number of parameters in prepared statement in D:\Servidor PHP\www\cadastrar.php on line 35

Warning: mysqli_stmt_bind_param(): Number of variables doesn't match number of parameters in prepared statement in D:\Servidor PHP\www\cadastrar.php on line 36

Warning: mysqli_stmt_bind_param(): Number of variables doesn't match number of parameters in prepared statement in D:\Servidor PHP\www\cadastrar.php on line 37

Warning: mysqli_stmt_bind_param(): Number of variables doesn't match number of parameters in prepared statement in D:\Servidor PHP\www\cadastrar.php on line 38

Warning: mysqli_stmt_bind_param(): Number of variables doesn't match number of parameters in prepared statement in D:\Servidor PHP\www\cadastrar.php on line 39

Warning: mysqli_stmt_bind_param(): Number of variables doesn't match number of parameters in prepared statement in D:\Servidor PHP\www\cadastrar.php on line 40

Warning: mysqli_stmt_bind_param(): Number of variables doesn't match number of parameters in prepared statement in D:\Servidor PHP\www\cadastrar.php on line 41

Warning: mysqli_stmt_bind_param(): Number of variables doesn't match number of parameters in prepared statement in D:\Servidor PHP\www\cadastrar.php on line 42

Warning: mysqli_stmt_bind_param(): Number of variables doesn't match number of parameters in prepared statement in D:\Servidor PHP\www\cadastrar.php on line 43

Warning: mysqli_stmt_bind_param(): Number of variables doesn't match number of parameters in prepared statement in D:\Servidor PHP\www\cadastrar.php on line 44

Editado Agosto 21, 2010 por rafaeldorazio