If you are migrating a database with business logic inside (typically SQL Server and Sybase) to Oracle, it can happen that translation process to freeze during converting a particular stored procedure or trigger.

The problem come up when finding lots of IF… ELSE loops inside the stored procedure and this will be solved in the next release of SQL Developer.

The solutions, as Dermot O’Neill said, are:

  • comment the ELSE keywords, translating it into /* ELSE */, then uncomment if after translation
  • delete the procedure from the captured model and skip it during translation
  • comment the code inside the procedure, or comment just some IF… ELSE loops

Good luck !

Read also

Tags: , ,
Leave a Reply