Archive for September 11th, 2008

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: , ,

Comments No Comments »

Half a year ago I bought an add-on for one hosting account that I have on . The add-on should be 3$/month, and they made a bill just for the first month. Starting with 30th of August they started to generate the invoices from the past like this:

There are some things that I don’t understand:

  • why the due date is before invoice date?
  • why they cannot aggregate all the old invoices in a bigger one
  • why they need to generate an invoice per day
  • why just after 1 day from invoice generation I am getting a notification with my password send in plain text

Later edit:
After paying all the invoices one by one, I cancelled the add-on and I am strongly thinking of cancelling the whole account.

Tags: , , ,

Comments No Comments »