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