OK so you’ve uploaded your images to APEX, created your list and want to select your image for your main parent item. But nothing is displayed in the list of values for the image field and even when you type in the value the same blank image is used. Fear not, the solution is simple. This baffled me for a little while and why Oracle have coded it like this can only be to test our determination to get this to work. DHTML List (Image) with Sublist is a simple, yet brilliant way to turn your application into a truly professional solution. Read the rest of this entry »

There has been a lot of confusion over Oracle licensing with regard to APEX. Surely Oracle can’t be providing something that’s free?! What’s the catch? As an Oracle Partner we’re able to develop software using Oracle products under the OTN development license which means it doesn’t cost us, however, this only covers developing and prototyping software. We’ve used APEX for internal applications such as a Flash application to record annual leave requests and to schedule work but as soon as we wanted to use this in a live environment we fell outside the OTN license, which meant we had to pay for a license. This is something my company wasn’t keen to do for internal applications. Read the rest of this entry »

For the past month we’ve been moving from a 9i database in a Windows environment to an Oracle XE database on Redhat Linux. A bit of a difference. As a software house we use Oracle products under a development license but because we wanted to go live with in-house developed APEX applications that fall outside the development license we faced moving to XE or paying for an Oracle license. What would you do? Read the rest of this entry »

I’m still trying to figure this one out and I suppose a bit of background will help. I work for a software house and the development department that I work in has two main products. One is Forms 10g sitting on an Oracle 10g database and the other uses the same database but has a front-end written using Java, eForms and Hibernate. There’s around about 100 designers, developers, testers and managers in this department and until about 2 years ago our internal processes were from the dark ages! We were requesting leave using a MS Word document and keeping track of schedules in a spreadsheet. We were developing fancy products for our customers, but internally we hadn’t progressed since the 90’s. Then someone mentioned Oracle Application Express, then called HTMLDB and I was asked to look at developing some internal applications. Read the rest of this entry »