Archive for april, 2012

Changes in sending email

Sending e-mails from within the Oracle database using the UTL_MAIL PL/SQL package used to be quite easy in Oracle 10g. However, in Oracle 11gR2, things have changed. Environment: Oracle database 11.2.0.3.0, Oracle Linux 6.2

Read More
apex_weekday1

Weekday Numbers in Apex sensitive to Application Primary Language

The weekday in Apex is dependent on of the language set in the Application Properties. For that you cannot rely on TO_CHAR(datevalue,’d’), but should use TRUNC(datevalue)-TRUNC(datevalue,'iw')+1 to get ISO weekdays, that are independent of the language set. SQL Workshop did

Read More

Blogging Platform,.. Free

You can now test the NinjaPress blogging platform on apex.oracle.com! Just follow the URLs below and you configure the blog, create articles, manage images, link, CSS settings and more. You only need an username or email to access the administrative

Read More

Jasper Reports Documentation

many of you might be using Jasper Reports for designing your reports with Oracle APEX. The documentation provided by Jasper Soft had to be paid for. I have just noticed that the Ultimate Guide is now available for free! So

Read More
01_Detail_Item

Saving Master Before Viewing Detail

Master Detail forms are an excellent way to manage a one to many relationship between tables. When using the declarative master detail form, clicking the edit link for a detail record does not save any changes that have been made

Read More

APEX interactive report aggregate cell font color

Here is how change style for APEX interactive report aggregate cell e.g when calculated value is negative. On this solution I pass aggregate cell value using Ajax to database. Application process checks passed values and returns JSON witch cells have

Read More

APEX Best Practices

When building many APEX applications, it is good to think about some best practices concerning as you go along. APEX is so easy to get started with, that many developers just start an application, as a prototype, and gradually this

Read More

Get client IP Address in APEX

Um die Client-IP-Adresse mit Hilfe von PL/SQL auszulesen, können Sie zwei unterschiedliche Prozeduren verwenden: select owa_util.get_cgi_env('REMOTE_ADDR') from dual; select sys_context('userenv','ip_address')   from dual; Das Ganze funktioniert super solange Sie keinen vorgeschalteten Proxy Server verwenden! Aber auch dafür gibt es einen

Read More

Interesting PL/SQL and Apex links

Here's a bunch of interesting stuff related to PL/SQL and Apex that I've come across lately, I'm posting it both as a reminder to myself, and to help spread the word:

Read More

Images in APEX interactive report

I'm quite sure that many APEX developers have face problems when using images in interactive report. There is e.g. problem in filter and when export report you see escaped image HTML tag.

Read More