Results 1 to 4 of 4
  1. #1
    Join Date
    May 2004
    Posts
    95

    Unanswered: Call procedure from PHP

    Hi all,

    I've got a stored procedure, which execute several steps.
    When I execute the procedure from PHP, the procedure stops at a random point, but when I execute from MySQL, the same procedure executes flawless.

    Does anyone have any kind of idea?

    Thanks.

  2. #2
    Join Date
    Sep 2009
    Location
    San Sebastian, Spain
    Posts
    880
    How long is your stored procedure running for? Could it be that there is some kind of timeout issue which is killing the process?
    Ronan Cashell
    Certified Oracle DBA/Certified MySQL Expert (DBA & Cluster DBA)
    http://www.it-iss.com
    Follow me on Twitter

  3. #3
    Join Date
    May 2004
    Posts
    95
    1 to 3 seconds on MySql

  4. #4
    Join Date
    May 2004
    Posts
    95
    got it...

    as I have dinamyc sql on the procedure, I execut the following steps:
    1. set the variable
    2. select the variable
    3. prepare a statment with the variable
    4. execute the statment
    5. deallocate the statment


    no problem executing inside MySQL, but from PHP this kind of treatment cannot have the variable selected.
    Just commented that line, and all worked fine.

Posting Permissions

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