Problems calling a stored procedure and results

[Takato Kinomoto]

Hi to all,

I have a stored procedure that return results but not in parameters... something like this:

CREATE PROCEDURE procname (IN p1 INT, IN p2 INT)
BEGIN
...
...
...
select something as atributename1,....,somethinn as atributn;
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 procname(5,5) }" and doesn't work), and with TQuery ("CALL ...") but then i cant request the results :S

Any suggestions?

i need the stored procedure to be executed and i need to get the results from the query to show it in the aplication!

please help

Thanks in advance.