Last post Nov 10, 2011 07:59 AM by mmazeemahmad
Nov 10, 2011 05:22 AM|mmazeemahmad|LINK
How to call a stored procedure in sqlyog enterprise that accepts a parameter of varchar
For e.g i have a following stored procedure
CREATE DEFINER=`akhan`@`000.000.000.10` PROCEDURE `GetCampaignTotalBouncedEmails`(p_MailChimpCampaignID varchar(50))BEGIN Bla bla bla END
And i am calling it in the query window as:
But it results 0 0 0 0
But when i writes
call GetCampaignTotalBouncedEmails( ' ' );
Colons with empty parameters it shows the result of '0' '250' '236' '13' in four columns etc etc
So what is the correct syntax to call it..........
Nov 10, 2011 06:58 AM|jassi_singh|LINK
Nov 10, 2011 07:59 AM|mmazeemahmad|LINK
That link was very generic i need to call a stored procedure that takes a varchar as an argument so how could i call it???