调用mysql 存储过程里面，不能操作打开关闭游标

Created 5 years ago by javahome, Updated 5 years ago Revision #1 2392 views 0 likes 0 collects

出现错误Packets out of order. Expected 1 received 4. Packet size=5 (SQL: call diaohao.char2())

我的代码

$users1 = DB::select('call diaohao.char2()');
dd($users1);

存储过程：begin

     declare dudu cursor
     for
     select id from test2;
     open dudu; #加上这句就出错
     close dudu;#加上这句就出错
    SELECT 'aa';
 end

Vote Vote Cancel

Collect Collect Cancel