Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to query/update a MySQL table from within a PL/SQL procedure

User_B9CVRApr 26 2021

Is there a way to connect to a MySQL DB from a PL/SQL stored procedure?
I want to query a MySQL table and get those records to a PL/SQL SYS_REFCURSOR or PL/SQL table.
Is this possible? I also want to IUD MySQL DB table rows from within a PL/SQL procedure.
How do you make the connection to a MySQL DB from within a PL/SQL procedure?
I know how to connect to MySQL from SQL Developer.
But this requirement is different. Here we want to do CRUD operations on MySQL DB from within PL/SQL.
Is this possible?

Comments
Post Details
Added on Apr 26 2021
7 comments
2,357 views