Migrating Oracle procedure to MariaDB

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.
LVL 17
Swadhin Ray Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

slightwv (䄆 Netminder) Commented:
I'm not a MariaDB Expert but I'm not aware of any other database product that runs 100% compatible PL/SQL code.

From what I've read about SQL_MODE, it allows some Oracle syntax to be used but I'm betting an existing Oracle procedure will run as-is.

Should be simple enough to just try it?
Swadhin Ray Author Commented:
The issue I see is on JSON part for conversion.  To utilize JSON on 11gr2 version we are using PLJSON utility and my worry is how to convert or translate it to MariaDB .
slightwv (䄆 Netminder) Commented:
>> we are using PLJSON utility and my worry is how to convert or translate it to MariaDB .

I saw that on Git when I looked up the calls you posted.  The options as I see them are you will need to ask the creator to port it for you, port it yourself or pay someone to port it for you.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Swadhin Ray Author Commented:
We need to rewrite it on MariaDB as addons like josn_table cannot be migrated.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today

From novice to tech pro — start learning today.