Mysql 8 stored procedure
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.
Subject
Views
Written By
Posted
Mysql 8 stored procedure
1337
June 12, 2020 12:47AM
618
June 12, 2020 12:52AM
489
June 12, 2020 03:01AM
502
June 12, 2020 11:17AM
499
June 14, 2020 01:39AM
383
June 14, 2020 10:53AM
480
June 15, 2020 06:13AM
549
June 15, 2020 12:29PM
504
June 15, 2020 12:46PM
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.