MySQL Forums
Forum List  »  Stored Procedures

Re: Procedure not working
Posted by: Peter Brawley
Date: December 29, 2019 12:06PM

> I have defined debug variable and no error
> raised when I load sql file and execute it.

That will canvass PHP errors. Apparently the sproc is failing in some way, that'll be an SQL problem.

Does the sproc populate rows when called in the mysql client program?

If so, what PHP API and version are you using, and let's see the code in your dbdelta() func that invokes the sproc.

Options: ReplyQuote


Subject
Views
Written By
Posted
1122
December 25, 2019 06:44PM
442
December 25, 2019 07:02PM
398
December 26, 2019 05:05PM
366
December 26, 2019 06:53PM
414
December 27, 2019 01:59AM
367
December 27, 2019 10:13AM
359
December 29, 2019 04:20AM
Re: Procedure not working
494
December 29, 2019 12:06PM


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.