The Oracle Database ships with a wonderful technology called Oracle Text
. Most people associate Oracle Text with the mere ability to index documents or data, perform text or phrase queries and get the results back. But Oracle Text can do so much more. One of the more interesting features of Oracle Text is the ability to analyze a document and generate a list of themes
for the document along with a weight associated with that theme.
In Oracle Application Express, unexpected exceptions can occasionally occur. Instead of communicating the technical details to an end user who is running the application, an error message will be issued of the form:Contact your administrator. Details about this incident are available via debug id "NN".
But what actually happened? Who is "your administrator"? And what exactly are you supposed to do with this information?
An internal exception occurred - it either wasn't properly (more...)
For OTN Appreciation Day
, I was told that it wouldn't be appropriate to write about my favorite Oracle feature (APEX
, obviously). So I'll gladly promote my second-favorite Oracle Database feature...Oracle Text
I've used Oracle Text for many years - from when it was SQL*TextRetrieval to Oracle ConText Option to Oracle interMedia Text to finally Oracle Text. This was one of those products that used to be a for-cost option and was (more...)
I received the following question via email today:"Had a question from a client yesterday concerning the subject: I want to know which database session (APEX_PUBLIC_USER) is servicing which APEX session. Poking around in the V$ tables, I can see that in v$SQL, the module column will reveal the APEX Application and Page, but not the Session ID. Even if the session ID was in there, I don’t see an obvious way to join back (more...)
If you are using Oracle REST Data Services
as the "PL/SQL Gateway" for Oracle Application Express
, ensure that your ORDS configuration includes the following line:
It is important that you do this, and let me explain why.
Fundamentally, the APEX "engine" is really nothing more than a big PL/SQL program running inside the Oracle Database. When a browser makes a request for a page in an APEX application, that request is mapped (more...)
Since the genesis of Oracle Application Express
, customers have asked for a way to open multiple browser tabs (or windows) of an APEX application and have the session state isolated between the respective tabs. There is one and only one APEX session associated with a client, and because of this behavior in APEX, customers would find that the session state manipulated in one browser tab would collide with the session state of the other (more...)
A minor but important change is happening for Oracle Application Express
in the forthcoming Oracle Database
12cR2. Specifically, Oracle Application Express will not
be installed by default in the Oracle Database. This change was made specifically at our request. We thought the pros far outweighed the cons, and we thought this was good for our customers and consistent with our recommendations.
- Provides flexibility for a DBA to run multiple APEX versions in an Oracle (more...)
As a lot of people know, apex.oracle.com
is the customer evaluation instance of Oracle Application Express
(APEX). It's a place where anyone on the planet can sign up for a workspace and "kick the tires" of APEX. After a brief signup process, in a matter of minutes you have access to a slice of an Oracle Database
, Oracle REST Data Services
, and Oracle Application Express, all easily accessed through your Web (more...)
Is Oracle Application Express
secure? That's the question I received today, from the customer of a partner. The customer asked:
"Do you know if Oracle or a third-party has verified how secure APEX is against threats or vulnerabilities? It would be nice to have something published saying how secure APEX is and how it’s never been compromised."
Now I imagine smart people like David Litchfield
or Pete Finnigan
or Alexander Kornbrust
would hope that (more...)
With the ever-changing browser landscape, we needed to make some tough decisions as to which browsers and versions are going to be deemed "supported" for Oracle Application Express
. There isn't enough time and money to support all browsers and all versions, each with different bugs and varying levels of support of standards
A position that's been adopted for the Oracle Cloud
services and products is to support the current version of a browser and (more...)
Last night (January 6, 2016) we had our first-in-2016 APEX Meetup meeting in Columbus, Ohio, USA
. For being on short notice, we had a nice turnout
, and I was able to distribute the new apex.world stickers. I was most impressed that a gentleman (by the name of Shannon) drove down from Cleveland, Ohio - almost 2 hours drive each way. He's been using APEX for all of two weeks, was using it with (more...)
, from the Oracle Database Insider Newsletter
, asked a number of us in the Database division at Oracle to share our New Year's resolutions for 2016. And while I'm a bit reluctant to share this somewhat personal information, I like the fact that publicizing these resolutions may force me to remain a bit more focused on these goals. So here goes...my resolutions for 2016:
- Attend an Oracle Real World Performance Training class. (more...)
When the APEX Gaming Competition 2015
was announced by Vincent Morneau
at the ODTUG Kscope15 conference
this past year, I was very suspect. I've seen many contests over the years that always seemed to have very few participants, and only one or two people would really put forth effort. Why would this "Gaming Competition" be any different? Who has time for games, right? Well...I could not have been more wrong.
I was (more...)
In the first part of October, my colleague Vlad Uvarov
and I are taking the Oracle APEX
& Oracle Database Cloud
message to a number of user groups who are graciously hosting us. These are countries for which there is growing interest in Oracle Application Express, and we wish to help support these groups and aid in fostering their growing APEX communities.
The dates and locations are:
- Latvian Oracle User Group, October 5, 2015
If you're not aware, there is an APEX Gaming Competition
which is already underway, and which is sponsored by the Oracle Development Tools User Group (ODTUG)
. For those who don't know what ODTUG is
, it is an independent user group and community of professionals, with a primary focus on the tools, products, and frameworks to build solutions and applications with the Oracle technology stack. Although ODTUG is based in the USA, they have members (more...)
At the upcoming ODTUG Kscope15
conference, on Monday night, June 22, there will be the Monday Community Events
. The Community Event for the Oracle Application Express track at Kscope15 is the ever-popular Open Mic Night. Without a doubt, this is one of my favorite events at the Kscope conference.
An Oracle employee sent me an email today, inquiring about the Open Mic Night. This employee, who is a user of Oracle Application Express at Oracle, (more...)
What started on a whiteboard in New York City more than 2 years ago is now finally realized. I and the other members of the Oracle Application Express team proudly announce the release of Oracle Application Express 5
The official blog posting and announcement is HERE
. But this is my personal blog, and the thoughts and words are my own, so I can be a bit more free.
Firstly, I don't ever want to see (more...)
The real title of this post should be "What I Really Meant to Say Was....".
Bob Rhubart of the Oracle Technology Network OTNArchBeat
fame was kind enough to give me an opportunity to shoot a 2-minute Tech Tip. I love Bob's goals for a 2-minute Tech Tip - has to be technical, can't be marketing fluff, and you have to deliver it in 120 seconds - no more, no less. So I took some (more...)