Andrei DANEASA

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

I’ve been asked many times if there is possible to install Oracle Application Express on Express Edition of 10g database, both of them being free products. The answer is YES, and the procedure is quite simple, as very well indicated on Oracle website

The steps would be: Read the rest of this entry »

Starting with 9th of June, a new version of SQL Developer was launched. This is more a patchset to previous version, solving a significant number of bugs.
I am very happy that the “Bug 6994152: ORACLE_HOME environment variable sometimes has an adverse affect on migrations” was solved, this being a very frequent topic on the migration forum. Now there is no need to create the .CMD file to overwrite ORACLE_HOME.
Another useful and very demanded feature is auto-expand of the connections list when open the tool.
Read the rest of this entry »

Sometimes, upgrading Oracle SQL Developer will not import your existing connections. You can have in the end an empty connection list. In order to import it, you just need to copy the connections.xml file from your old location like this:

to your new location like this:

Another version would be, when upgraded version of SQL Developer is asking for the path to the connections file, just provide him the path to the old version.

Good luck!

UPDATE 2008-11-05! A console version is available here

Since I had more and more requests for DBF migrations to Oracle and SQL Developer offers no support for DBF migrations, I decided to make a tool to ease my work. There used to be a command prompt tool (ImpDBF.exe) which generates the equivalent table for Oracle and SQL*Loader scripts for importing the data. This tool was for Oracle 7 and 8 and I don’t have the source code for this tool.

The workaround was to create a frontend for that tool that can also fix problems in generated files.
The result is the like this:

Read the rest of this entry »

I wrote a lot how to install loopback adapter, how to set the ip address (either manual or automatically), how to add an entry to hosts file (either manual or automatically). Now let’s add all together into a single script.
The script will do the following:

• call DevCon to install Microsoft Loopback Adapter (you need to download DevCon and save it in the same folder as the script)
• set the IP address and mask for the recently installed loopback adapter
• dinamically read from Windows folder the hosts file
• dinamically read the hostname
• add a new entry to the hosts file with the supplied IP address and hostname
• ping the hostname and check if the supplied IP address is responded
• MOST IMPORTANT: everything is dynamic and automatic. You don’t need to edit the script before each install. Just run it!

You can download this script here: Read the rest of this entry »

As a common practice all the servers have fixed IP address. Because not all Oracle Databases are installed directly on servers, but on laptops or different machines, it’s very probable that you have DHCP-provided IP address.
If you have DHCP IP address, your full computer name may vary, because different domain is added to computer name. Once the name can be mylaptop.oracle.com, the next day the name can be mylaptop.myhomenetwork.ro and so on.
The problem is when you want to install Oracle Database Enterprise Manager (web-based administration tool), because the installer is creating a folder on the disk have the name based on fully computer name. If you change the network the Enterprise Manager will not work, because it will not find a folder based on the actual computer name.
Enterprise Manager is not crucial , it’s just an interface, so if you don’t want to install it your database will work the same and you will configure the database through SQL*Plus or SQL Developer or Toad or what third party admin you want.
Read the rest of this entry »

First of all… happy new year!

I hope that the new year will bring me back my mood. In the last months I did nothing than my usual office work and downloads at home.
I was extremely surprised to see how many visitors I had on my blog just in December, even than the last update was in May 2007.

So I decided to update more frequently the blog. The topics will be the same: Oracle (being my current employer), HTML and web technologies (being my favorites), .NET and sometimes some personal posts.

Good luck in 2008,
Andrei