I was attempting to replicate the navigation bar example from the Opportunity Tracker application and I noticed my application was missing icons from the sub list dropping off the username.
|Icons in submenu when visible|
Here are the relevant User Interface settings for the Navigation Bar
|User Interface settings|
It turns out in newly created application with Theme 42 the following is used as the sublist entry template<li data-current="true" data-icon="#ICON_CSS_CLASSES#"><a href="#LINK#">#TEXT_ESC_SC#</a></li>
In my application (more...)
Maybe you realize how difficult it is to go from an idea to a successful company. Maybe you've attempted one (or more) yourself. Is the American dream a startup? It is for some, but not all. If you start a company and you're the only employee and you don't get paid, is your business a startup? Is it successful? Beauty and success are in the eye of beholder. You might hear people suggest you set (more...)
I love analogies that are very meaningful and get the point across. I often hear businesses talking about different subjects that concern them. You could say this is similar to the days of the old west where people carried their weapons on their belt and used them at will. Back then, did people worry about the 4th bullet in the gun? Of course not. They worried about the 1st bullet.
So why is it that (more...)
If you've upgraded to APEX 5 and find yourself with an error complaining about the 'Source Used' attribute:APEX.SESSION_STATE.DB_COLUMN_SOURCE_USED
then you should thank APEX 5 for finding (and no longer tolerating) a logic bug in your application.
|APEX 5 - correcting your applications|
Track down that field and set the Source Used attribute to 'Always, replacing any existing value in session state'.
On a side note, setting the application's Compatability Mode to 4. (more...)
Using an Oracle object type’s instance in a query is a powerful capability. Unfortunately, Oracle’s SQL syntax doesn’t make it immediately obvious how to do it. Most get far enough to put it in a runtime view (a subquery in the from clause), but then they get errors like this:
ERROR AT line 4:
ORA-00904: "INSTANCE"."GET_TYPE": invalid identifier
The problem is how Oracle treats (more...)
Can you think of anyone worthy of being recognised in the following areas?
|Developer Choice Awards Categories|
Today is the last day for nominations, so visit the website
and nominate the first person you think of - right now
From mid next month you will have a chance to vote for the finalists.
It looks like Oracle are trying really hard to be more involved with the community, so I think good on them for this initiative.
There is quite a debate going around based on Simon’s linkedin post regarding the future of Forms; but when you read it you’ll see, he doesn’t actually talk about the future of Forms – he talks about the demise of Forms and its replacement with Oracle APEX. As someone who does believe in the future of forms, there are several things I wanted to clarify.
Firstly, it mentions that despite the release of Oracle Forms 12c, Oracle (more...)
Jonathan Lewis hat - wieder einmal angeregt durch entsprechende Fragen in den OTN-Foren - einen Artikel zur Frage geschrieben: welche Informationen muss man analysieren, um bestimmen zu können, ob ein Index gefahrlos gelöscht werden kann? Bisher ist es zwar nur ein Artikel, aber da ein zweiter angekündigt ist, mache ich gleich eine Aufzählung daraus:
Erklärt zunächst das grundsätzliche Probleme extremer Indizierung: zwar wird - potentiell - die Treffsicherheit der Zugriffe erhöht, aber man (more...)
|APEX 5 change region type|
If only to further emphasise some of the fundamental rebuilds APEX 5 must have undertaken, look at the ability to switch region types.
Prior to APEX 5.0, we could migrate a Classic report to an Interactive Report, but not the reverse. And don't even think about switching to another region type.
Just bear in mind the tweaks and adjustments you'd probably lose as you toggle around. I think it (more...)
My thoughts on SQL plan management decision points:
SQL Patches are also available and not covered in the above flowchart.
Almost five years ago I introduced Kylie
to our little Sage
Now she ventures into the world of blogging. She'll no doubt talk about Oracle development in some form, either SQL, PL/SQL, APEX, or for some bizarre reason, JDeveloper.
But who knows where blogging leads, huh? Check her out atdancingwithoracle.com
Aptly named after her passion for dancing.
She's got a related twitter account:@dancingwithoracle
Each application needs a simple way to log errors and find them. The following technique can also be used to debug Forms, Reports and PL/SQL. This version 2.0 has an important change. The username ist stored in the debugging-data and the viewname has changed a little bit.
First create the table, sequence and view to store the logging-information:
CREATE TABLE Logging (
ID NUMBER(9) NOT NULL,
INSERT_DATE DATE NOT NULL,
INSERT_USER VARCHAR2(30) (more...)