An example of a user-defined aggregate function

Always check out the original article at http://www.oraclequirks.com for latest comments, fixes and updates. May be user-defined aggregate functions are not among the most frequent hits in the life on a PL/SQL or APEX developer, but today I wanted to find an elegant solution for a problem submitted by a customer without reinventing the wheel: given a report containing the labor expressed as

Oracle Application Express (APEX) 4.2.5 is now available for download

A new minor release of Oracle Application Express (APEX) has been announced yesterday. Version 4.2.5.00.08 is now available for download. Check out the accompanying documentation for new features and bugs fixed in this release. You may also find interesting reading Joel's blog posting about Apex 4.2.5.

On HTTP 401 Unauthorized (with Oracle EPG)

Always check out the original article at http://www.oraclequirks.com for latest comments, fixes and updates. It could happen that suddenly your Apex application that has been working for years starts asking for a username and password in order to access the XDB repository. You hit the Cancel button and all you get is:   401 Unauthorized No html, no images, nothing is returned, your app is

Random XDB authentication problems with Apex and EPG: problem solved? So it seems.

Always check out the original article at http://www.oraclequirks.com for latest comments, fixes and updates. This is the sort of things I hate, because I cannot fully explain why it works the way it does, anyway, here is a short account of what happened: Some time ago I installed Oracle XE 11g on an Oracle Linux VM. Upgraded Apex to 4.2.3 Installed all my applications with little effort if we

Oracle Application Express (APEX) 4.2.4 is now available for download

Somewhat unexpectedly, at least for me, Joel Kallman announced a new iteration of Apex. Enjoy

SQLDeveloper 4.0 is now production and ready for download

SQLDeveloper 4.0 is available for download now.

SQL Developer 4.0 Early Adopter 3 is available for download.

A new iteration in the early adopter release cycle is available for download now.

Oracle Application Express 4.2.3 is here

In case you didn't read the news somewhere else, the latest and greatest version of Apex (4.2.3) has been made available for download. Patch set notes include a long list of bug fixes. Thanks to Joel Kallman for the timely announcement.

DECOMPOSE this: when what you see is not exactly what you think you see

Always check out the original article at http://www.oraclequirks.com for latest comments, fixes and updates. I was trying to call function DECOMPOSE while investigating a strange problem I had with some Unicode strings that could not be properly indexed by Oracle Text and, amazingly, I found out that most (more...)

APEX_MAIL package and views quick reference

Always check out the original article at http://www.oraclequirks.com for latest comments, fixes and updates. APEX_MAIL is the API package for sending emails from Oracle Application Express. In order to be able to execute APEX_MAIL procedures and/or check the related views outside of Apex (from SQL Developer or from (more...)

D-I-Y apex_mail_log maintenance and an Apex feature request

A couple of days ago I submitted a feature request via the Apex Feature Request application because I believe that workspace administrators should be given the possibility of purging the apex mail log if they want to (see feature request AG3A). If you agree with my request, you're kindly invited (more...)

SQL Developer 4.0 Early Adopter Release 1 is out

In case you missed it, SQL Developer 4.0EA1 is available for download.

New OTN forums, old problems?

Nice fresh look, but unfortunately this morning it keeps kicking me out whenever I try to access the Apex forum, not to talk about the slugginesh of the log-in (it takes 30 seconds or more to get in, just to be thrown back to the dashboard instead of keeping me (more...)

How to translate and use Apex text messages inside javascript code and other considerations about shortcuts

Always check out the original article at http://www.oraclequirks.com for latest comments, fixes and updates. For a long time I thought that whenever I had to display a translatable message inside JavaScript the only way forward was to create an Apex shortcut containing plain text. An Apex shortcut is (more...)

How do I turn off format autodection in Safari?

Always check out the original article at http://www.oraclequirks.com for latest comments, fixes and updates. Your Apex mobile page looks weird because Safari is formatting automatically certain strings containing numbers mistaking them for telephone numbers? You just need to add a meta tag in the head section of the (more...)

invalid LOB locator specified: ORA-22275

Always check out the original article at http://www.oraclequirks.com for latest comments, fixes and updates. Just a simple reminder (I tend to forget things over the centuries) when using procedure DBMS_LOB.CONVERTTOCLOB with persistent lob locators: don't forget to include the FOR UPDATE clause in the SELECT statement fetching (more...)

LPX-00209: PI names starting with XML are reserved

Always check out the original article at http://www.oraclequirks.com for latest comments, fixes and updates. I don't know why it took me more than the necessary to understand where was the problem when I hit the following error. ORA-31011: XML parsing failed ORA-19202: Error occurred in XML processing LPX-00209: PI names starting with XML are reserved At any rate, in my case the reason was

Apex Text Messages as substitution strings – Wanted

Always check out the original article at http://www.oraclequirks.com for latest comments, fixes and updates. If you, like me, think that it could be useful having text messages available as substitution strings (ideally using the #syntax#) inside certain Apex's element attributes like button attributes, report links, form attributes and so on, then you might want to vote for this feature request

#COLUMN_WIDTH# in Apex report templates

Always check out the original article at http://www.oraclequirks.com for latest comments, fixes and updates. Even if the topic is no breaking news, there are some references about it in the Apex OTN forum, it may be still worth spending a few words, especially because, up to date (Apex 4.2.1), there is no trace of it in the official Oracle Application Express documentation. I am talking of the

Apex 4.2.1 is here

Apex 4.2.1 has been made available for download today. I recommend checking out Joel Kallman's blog posting for the details (bug fixes, patch notes and release notes). Enjoy