Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2004
    Posts
    17

    Unanswered: Execute stored procedure from another stored procedure

    Hi,

    Does anybody know what the syntax is for executing a stored procedure from within another stored procedure?

    IE. execute SP2 inside SP1

    Many thanks in advance

  2. #2
    Join Date
    May 2005
    Posts
    127
    hi,
    you can call an SP from within another SP just like calling it from MySQL client. but instead of passing session variables as SP parameters you can use local variables that have been declared in your parent SP.
    just call your SP like this:
    Code:
    call spName(parameters);
    Regards
    Chagh

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •