laravel存储过程错误


laravel stored procedure error

我在尝试使用存储过程注册用户时遇到以下错误
非常感谢您的帮助。

错误:SQLSTATE[42000]:语法错误或访问冲突:1318 PROCEDURE tls_db.insert_customer的参数数量不正确;应为7,得到0(SQL:call insert_customer)

controller
    $user   = array(
                'email' => Input::get('email'),
                'password' => Input::get('password'),
                'username' => Input::get('username'),
                'PhoneNumber' => Input::get('PhoneNumber'),
                'CustomerName' => Input::get('CustomerName'),
                'CustomerSurname' => Input::get('CustomerSurname'),
                'CustomerAddress' => Input::get('CustomerAddress'));
                $data = new user($user);
                $data->save();
                user::storedProcedureInsert_customer();
                return Redirect::to('/');
model
    public static function storedProcedureInsert_customer() {
         return DB::statement('call insert_customer');
    } 

insert_customer过程需要七个参数,但您没有提供任何参数。

你最好用参数化的语句来调用它,比如:

DB::statement('call insert_customer(?, ?, ?, ?, ?, ?, ?)', [Input::get('email'), Input::get('password'), Input::get('PhoneNumber'), Input::get('CustomerName'), Input::get('CustomerSurname'), Input::get('CustomerAddress')]);