MySQL Forums
Forum List  »  Stored Procedures

Mysql 8 stored procedure
Posted by: Zoltan Szmutku
Date: June 12, 2020 12:47AM

Hello Sirs
I have a program with ANSI ODBC 32 connect interface and many stored procedures on the server side. It is works since four years but now we must upgrade the server and driver from 5.6 to 8.0.2 .
We solved several problems for changed parameters but we have one incomprehensible problem with a stored procedure.

It is make SQL exceptions randomly. We install a new program, upload databases and routines and sometimes we got various error messages from stored procedures. (SQL syntax errors and more others)
Sometimes it works well without any interaction. Install, and go.
But sometimes it gets well only after we access to datatables with Heidi or Workbench. (Insert and delete a row manually after the program works fine)
But this way is not works all times. Sometimes we need do it 2x, 3x .

When we upgrade 5.6 server and installed databases then never gets error. Only with new Mysql8 installation.
It is a hungarian language program and databases and the stored procedures contains comments with our spec characters. We tried to delete our spec characters with program before upload procedure to the database but nothing.

Do you have any idea for this?
Thanks in advance.

Options: ReplyQuote


Subject
Views
Written By
Posted
Mysql 8 stored procedure
467
June 12, 2020 12:47AM
192
June 12, 2020 12:52AM
106
June 12, 2020 03:01AM
129
June 12, 2020 11:17AM
104
June 14, 2020 01:39AM
85
June 14, 2020 10:53AM
88
June 15, 2020 06:13AM
107
June 15, 2020 12:29PM
129
June 15, 2020 12:46PM


Sorry, only registered users may post in this forum.

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.