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
500
June 12, 2020 12:47AM
226
June 12, 2020 12:52AM
115
June 12, 2020 03:01AM
140
June 12, 2020 11:17AM
112
June 14, 2020 01:39AM
93
June 14, 2020 10:53AM
95
June 15, 2020 06:13AM
120
June 15, 2020 12:29PM
137
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.