How to call a stored procedure from a stored function with parameter?

Hello,

I have the following stored procedure

PROCEDURE `IsProductInForeignDatabase`(IN stock INTEGER(11), OUT MyResult VARCHAR(1000), IN Behaviour VARCHAR(20))

The procedure above returns the "MyResult" out parameter.

I have a stored function as well thas has the body:

Begin
Declare MyResult VARCHAR(1000);

set MyResult = '';

call `IsProductInForeignDatabase`(1, MyResult,'question');

Do you need help?

In addition to our free technical library, Pantek provides professional IT services to companies who utilize Open Source software: Learn more about Pantek's Technical Support offerings Place an order for 24/7/365 Technical Support here Learn more about Pantek, who we are, and what we do Chat with a Live Operator Related lists.mysql.com Links announce benchmarks bugs certification cluster commits dotnet gui-tools internals java maxdb myodbc mysql mysqldoc packagers perl plusplus replication win32 Request more information about Pantek

RETURN 50;
END; In the code above the "return 50" is only a test: if I use the "call" statement in the body then the function will return nothing at all, on the contrary when I don't use the "call" statement, then it returns 50.

The problem should be with the "MyResult" variable, but I don't know what to do.
I tried with "@" sign, with no difference.

It is interesting that if I call the procedure within an Sql window it works perfectly like this:

CALL `IsProductInForeignDatabase`(1, @w,'question'); SELECT @w;

If it worked the end of the function would be "return MyResult".

Thank you in advance

Zsolt Csillag

www.egyediszoftverek.hu
www.starsoft.hu Received on Sat Sep 29 16:33:48 2007

Do you need more help?

In addition to our free technical library, Pantek provides professional IT services to companies who utilize Open Source software: Learn more about Pantek's Technical Support offerings Place an order for 24/7/365 Technical Support here Learn more about Pantek, who we are, and what we do Chat with a Live Operator Related lists.mysql.com Links announce benchmarks bugs certification cluster commits dotnet gui-tools internals java maxdb myodbc mysql mysqldoc packagers perl plusplus replication win32 Request more information about Pantek