Can't get stored procedure work in Delphi7/BDE

[Enrique Castillo]

Hi to all,

I have a basic stored procedure

CREATE PROCEDURE `database`.`sp_name` (IN p1 VARCHAR(10), OUT p2 INTEGER)
BEGIN
START TRANSACTION;
UPDATE SomeTable SET SomeFields = SomeValue WHERE SomeField = p1;
SELECT p2 = SomeField FROM SomeTable WHERE SomeField = p1;
COMMIT;
END

It works fine in the Query Browser, but i can't get it to work in delphi 7.

I've tried TStoredProc (but it sends it with brackets like this "{ call `sp_name`('p1',b) }" and doesn't work), and with TQuery ("CALL ...") but it shows the error message "OUT or INOUT argument...".

Any suggestions?

Thanks in advance.