How to get stored procedure result set to other stored procedure. Or return table in function in MySQL -
my first stored procedure returns 3 values use in stored procedure. tried this:
create definer=`db`@`%` procedure `sp_expense`( flightinstanceid int ) begin select f.basefare, call sp_orderdetail(f.fareid) fare; end$$
but i'm getting syntax error.
is possible in functions? return table ?
you cant call stored procedure in select statement. doing trying call function. create fucntion. if understand question sp_orderdetail(f.fareid) returns table? wonder if turn sp_orderdetail(f.fareid) view instead?
this might well: create stored procedure , create function syntax
Comments
Post a Comment