MySQL Forums
Forum List  »  Delphi

Can't get stored procedure work in Delphi7/BDE
Posted by: Enrique Castillo
Date: August 17, 2006 04:30PM

Hi to all,

I have a basic stored procedure

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

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.

Options: ReplyQuote

Written By
Can't get stored procedure work in Delphi7/BDE
August 17, 2006 04:30PM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.