[exim] calling mysql stored procedures from Exim

Top Page
Delete this message
Reply to this message
Author: Dan_Mitton
Date:  
To: exim-users
Subject: [exim] calling mysql stored procedures from Exim
I am trying to call a mysql stored procedure which returns a results set
to Exim:

${lookup mysql{servers=host/foo/user/password; call
bar('stuff')}{$value}{not found}}

but I'm getting the error:

gave DEFER: MYSQL: query failed: PROCEDURE foo.bar can't return a result
set in the given context

the procedure looks like (yes, the names have been changed to protect the
inicent, but it really is a one line sp):

create procedure bar(p varchar(32))
begin
select col1,col2,col3 from tab1 where col4=p;
end

From the command line, the mysql client runs this sp just fine and returns

results.

Any ideas from anyone??

Thanks,

Dan