Have you installed or recently upgraded to Oracle APEX Listener 2.0? Have you used SQL Developer 3.2 to manage APEX Listener settings? If you answered yes to both questions then you are in for an unwelcome surprise.

The surprise is that you’ll get a “500 – Internal Server Error” whenever you upload a file via any of your APEX apps or import files via the APEX Application Builder.

If you are still hesitant to join Twitter, I hope that this post has given you an incentive to join this growing social network. Many Oracle employees, like Kris, are active on Twitter and listening to people like you and me who use their products on a daily basis.

To make it easier for you to follow Oracle people on Twitter, I have created this Oracle list. The list occupies a permanent column on my Tweetdeck stack.

I have experienced this behavior too. It is really frustrating when it happens. The solution, however, is really simple. In SQL Developer, go to Tools > Preferences > Code Insight and uncheck both “Enable Auto-Popup” check boxes as seen in the following screenshot:

Now, instead of letting it load automatically, you control when the context sensitive code completion insight popup appears. Simply press Ctrl+Space and voila.

Oracle SQL Developer, the free graphical tool for database development, has just been upgraded from 1.1 to 1.2. Here is the list of bug fixes and here is the release notes document including new features and known issues.

If you are already running production release 1.1 (v 1.1.0.23.64) or above, you can use Help > Check for Updates to update your SQL Developer environment. Otherwise, you can download Oracle SQL Developer 1.2 from here.

When you code, you write your programs either in all lower case, all upper case, or a combination of the two. Let’s take PL/SQL for example, almost all PL/SQL programming best practices and coding styles that I’ve come across recommend using upper and lower. The following is an excerpt from the book Oracle PL/SQL Best Practices By Steven Feuerstein: Continue reading…

In this global economy the need for software globalization is increasing. As a result of this globalization, localization is becoming an important part of software development. And as a result of this localization, software developers like myself will have to work with multiple languages. So, it is becoming more crucial to have development tools that support multi-byte in addition to single-byte characters, like Chinese versus English for example.

As an Oracle database developer I have been using Quest Software Inc.’s SQL Navigator for years. We are currently involved in the implementation of Oracle E-Business Suite in our new plant in China. So, now we have the Chinese characters to worry about. It turns out that SQL Navigator does not support multi-byte characters and UTF8 encoding (which is needed to display Chinese characters), however, Oracle’s SQL developer does 🙂

Here is how SQL Navigator displays a query result that returns Chinese characters: Continue reading…