The amazing ANSI join syntax quirk

Uncategorized
| Aug 28, 2017
The kind of quirks I love: those that you can find a workaround for without having to wait for a patch.I am talking Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production running on some unix flavor (I ignore which flavor, I've no access to the unix box).You execute the following query and it works.select f.cuaa,f.id_fgra, d.id_cons, c.id_part, p.id_prt,        

SQLDeveloper 4.2 problem with some bind variables values

Uncategorized
| Aug 7, 2017
I just found out that SQLDeveloper version 4.2.0.17.089 (tested on windows 10) might execute SQL or PL/SQL code containing bind variables with wrong argument values when such values are strings (VARCHAR2) containing just digits with leading zeros (i.e. international phone numbers, VAT codes, UPC codes...) entered at the bind variables prompt.This seems to happen only with PL/SQL code or certain

The importance of being CURRENT_USER

Uncategorized
| Jul 7, 2017
Say I am user FLAVIO.SCHEMA1 is another schema.I have been granted EXECUTE and DEBUG privileges on SCHEMA1.TEST_PROC through a role.Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit ProductionIf I perform a query like this:  select s.owner, s.name, s.type, s.line, s.text    from all_source s   where s.owner = upper('SCHEMA1') and         s.name = upper('TEST_PROC') and         

Fire an employee? It’s that easy!

Uncategorized
| Jul 4, 2017
I love the sense of humor Larry puts in his documentation :-)

Apex 5.1.1 released

Uncategorized
| Mar 29, 2017
The latest version of Oracle Application Express has been made available yesterday for download from Oracle as reported by Joel Kallman. As usual a number of issues and bugs have been fixed, read more in Apex 5.1.1 patch set notes. Enjoy.

Apex 5.1 Application Builder Overview

Uncategorized
| Jan 20, 2017
The latest video about the Application Builder in Apex 5.1 from Oracle's Senior Principal Product Manager David Peake.

Oracle Apex 5.1 is here

Uncategorized
| Dec 21, 2016
Oracle Apex 5.1 is now production and available for download.

Off topic: finally a really good online OCR service

Uncategorized
| Nov 16, 2015
Sometimes I need to import printed documents like contracts, letters and so on, but I must say that until yesterday my attempts to successfully scan these stuff with online OCR services had gone badly. Most of the times, in the past, the number of wrong words, letters converted into numbers, typically "l"s would become "1"s, "O"s would be turned into "0"s, "A"s into "4"s, quickly led me to

Error: parsererror – SyntaxError: JSON.parse: unexpected non-whitespace character after JSON data at line 2 column 1 of the JSON data

Uncategorized
| Nov 10, 2015
Always check out the original article at http://www.oraclequirks.com for latest comments, fixes and updates. Error: parsererror - SyntaxError: JSON.parse:  unexpected non-whitespace character after JSON data at line 2 column 1 of the JSON data You may get this self-explanatory error at run-time if you specified a non-existing page item in the list of items to be returned after invoking a PL/

About displaying images using APEX_UTIL.GET_BLOB_FILE_SRC in non trivial situations

Uncategorized
| Nov 9, 2015
Always check out the original article at http://www.oraclequirks.com for latest comments, fixes and updates. In a perfect situation, when we need to display an inline image inside an Apex report, we might simply pick the BLOB column and apply the special formatting required in these cases, I mean that weird format mask containing a list of column attributes separated by colons where each member

AC Adapter can prevent powerline adapters from working if plugged in nearby sockets

Uncategorized
| Oct 22, 2015
I just found out yesterday night that plugging my Apple branded Macbook Pro's AC Adapter into an electrical multioutlet caused the nearby powerline adapter to stop working completely. While it is certainly true that the powerline installation guide recommends to NOT plug the adapters into multioutlets, it must be said that until yesterday it was working just fine in that way. Removing Mac's AC

Apex 5.0.2 released

Uncategorized
| Oct 21, 2015
A new iteration in the lifecycle of Oracle Application Express just landed. Apex 5.0.2 is available for download now. You can read about the bugs fixed in this release in the accompanying Patch Set Notes. Enjoy

Oracle Application Express (APEX) 5.0 available for download

The best Oracle Application Express edition of all times has finally landed. Info & details in Apex's official blog. Enjoy.

Apex multilingual applications and build options

Always check out the original article at http://www.oraclequirks.com for latest comments, fixes and updates. Just a quick reminder for those who are devoloping Apex multilingual applications: Build options' state is propagated to translated applications at the time of seeding, so you need to be careful when changing the state of a build option in the primary language because you may end up

ORA-20104: create_collection_from_query ParseErr:ORA-00918: column ambiguously defined

Always check out the original article at http://www.oraclequirks.com for latest comments, fixes and updates.   If you are wondering why you are getting this error message after following the example in the documentation describing procedure CREATE_COLLECTION_FROM_QUERYB2 in the APEX_COLLECTION API, the quick answer is that the sample code is flawed. ORA-20104: create_collection_from_queryb2

Apex substitution strings in reports, not always replaced with their values, guess why?

Always check out the original article at http://www.oraclequirks.com for latest comments, fixes and updates. It's amazing to you find out how easy is to take for granted certain features of Apex for the simple fact that you have been using them for a long time without paying too much attention to certain specific details. This morning I ran a report that I rarely use in an application and to

How many page views can Apex sustain when running on Oracle XE?

Always check out the original article at http://www.oraclequirks.com for latest comments, fixes and updates. While some people think that hosting a web site on top of Oracle XE can be hardly considered much more than a joke, I can claim instead, basing on my personal experience of the last 5 years, that for small sites it can be a perfectly reasonable choice, provided you have the technical

ORA-29339: tablespace block size 16384 does not match configured block sizes

Always check out the original article at http://www.oraclequirks.com for latest comments, fixes and updates. If you attempt to create a tablespace with a non-standard blocksize, say 16K, you get an exception like this: ORA-29339: tablespace block size 16384 does not match configured block sizes In order to create the tablespace, you'll need first to allocate a specific buffer for these blocks

Time for an Oracle Apex feature request – single sign-on authentication

I've just submitted a feature request because I believe that the current Application Group concept is a fairly weak one if it doesn't bring about some advantage in terms of features for the developer. Basically what I am asking for is that one can easily implement a single sign-on authentication method across multiple applications within the same application group, pretty much like the existing

SQLDeveloper 4.0.3 is available for download

One more iteration in SQLDeveloper's development cycle, you can now install version 4.0.3 I am curious to see what happens with my shared SQL History on Dropbox after the update.