locked
How to call a stored procedure in sqlyog enterprise that accepts a parameter of varchar RRS feed

  • Question

  • User670644709 posted

    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:
    call GetCampaignTotalBouncedEmails(mycampaign_id_here);
    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..........
    Thursday, November 10, 2011 5:22 AM

All replies

  • User1927273029 posted

    Refer: http://webyog.com/faq/content/14/81/en/is-it-possible-to-execute-stored-procedures-from-sqlyog_sja-_sql-scheduler-and-reporting-tool_.html

    Thursday, November 10, 2011 6:58 AM
  • User670644709 posted

    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???

    Thursday, November 10, 2011 7:59 AM