MySQL: Not allowed to return a result set from a trigger -

MySQL: Not allowed to return a result set from a trigger -

i'm getting "error 1415 (0a000): not allowed homecoming result set trigger" when updating table containing next trigger, don't understand why.

create trigger my_trigger after update on my_triggering_table each row phone call my_procedure();

i'm away triggers cannot utilize select returns result set, called procedure (and children) utilize cursor select , fetch which, understand, permitted. read, not modify, triggering table.

can explain error? (mysql 5.5) called procedures below.

create procedure my_procedure() begin declare v_mark varchar(4); declare v_lat, v_lon double; declare eof int default false; declare my_cursor cursor select `mark`, `lat`, `lon` my_triggering_table order `order`; declare go on handler not found set eof = true; delete my_output_table; open my_cursor; loop1: loop fetch my_cursor v_mark, v_lat, v_lon; if eof leave loop1; end if; phone call my_procedure_2(v_mark, v_lat, v_lon); end loop; close my_cursor; end// create procedure my_procedure_2(in from_mark varchar(4), in from_lat double, in from_lon double) begin declare v_mark varchar(4); declare v_lat, v_lon double; declare eof int default false; declare my_cursor cursor select `mark`, `lat`, `lon` my_triggering_table order `order`; declare go on handler not found set eof = true; open my_cursor; loop1: loop fetch my_cursor v_mark, v_lat, v_lon; if eof leave loop1; end if; insert my_output_table(`from`, `to`, `dist`, `brg`, `lat`, `lon`) values(from_mark , v_mark , if(from_mark = v_mark, null, getdist(from_lat, from_lon, v_lat, v_lon)) , if(from_mark = v_mark, null, getbearing(from_lat, from_lon, v_lat, v_lon)) , coord_dec2ms(from_lat, true) , coord_dec2ms(from_lon, false) ); end loop; close my_cursor; end//

the udfs called not reference tables.

mysql triggers