This content has been marked as final. Show 2 replies
If you check the information about MySQL migrations here -
it does not list stored procedures as being supported for migrations although I cannot see where this is explicitly documented elsewhere.
You could try converting the MySQL stored procedures to Oracle syntax by using the Translation Scratch Editor from the main menu -
- Translation Scratch Editor
We don't have SQL parser for MySQL in SQLDeveloper yet. So it cannot migrate views, stored procedures,tirggers in the current release. If you have significant number of views/procedures/triggers then you may want to consider commercially available tools for such migrations.