Migrating Oracle procedures which has JSON data as input and business validation to insert/ update/delete tables to MariaDB.
Can we use SQL_MODE to ORACLE and use the same procedure ? Or we need to rewrite it again.
Like few differences where we use JSON_PARSER.PARSER(<<my input JSON>>) or JSON_EXT.GET_NUMBER / JSON_EXT.GET_STRING in Oracle to get the values for specific keys. So can we directly use the same procedure to work on Mariadb by setting the mode or we need to rewrite the entire procedure.