Home » APEX
Category Archives: APEX
Sending a SMS to a mobile phone from APEX and PL/SQL
![](https://orapedia.wordpress.com/wp-content/uploads/2013/08/patrickwolf.jpg?w=960)
Sending a SMS to a mobile phone
This article from Inside Oracle APEX by Patrick Wolf
The article direct link Sending a SMS to a mobile phone
Summary
this article explains how to sending a SMS from APEX and PL/SQL through a Web-Service. For example if you have a system failure or get a new order in your shop…
Oracle APEX the server requires a username and password the server says XDB
![](https://orapedia.wordpress.com/wp-content/uploads/2013/01/mohammadfawzy.jpeg?w=960)
Oracle APEX the server requires a username and password the server says XDB
This article from Mohammad Fawzy
The article direct link Oracle APEX the server requires a username and password the server says XDB
Summary
After install APEX on enterprise edition database you will get the following message if you try to connect to APEX “the server requires a username and password the server says XDB”
In a new installation, we must configure the embedded PL/SQL gateway by running the configuration script apex_epg_config.sql. Then, we must unlock the ANONYMOUS account.
Moving your APEX Application to the Oracle Cloud
![](https://orapedia.wordpress.com/wp-content/uploads/2013/02/dimitrigielis.jpg?w=960)
Moving your APEX app to the Oracle Cloud
This article from Dimitri Gielis Blog (Oracle Application Express – APEX)
The article direct link Moving your APEX app to the Oracle Cloud
Summary
Now that the Oracle Cloud is publicly available, I want to show you what it takes to put your APEX application on there.
Oracle APEX upload a text file and write into a table
![](https://orapedia.wordpress.com/wp-content/uploads/2013/02/ittichaichammavanijakul.gif?w=960)
Oracle APEX upload a text file and write into a table
This article from OraExplorer
The article direct link Oracle APEX upload a text file and write into a table
Summary
One of the web development projects using Oracle APEX I’m working on is to upload the content of a text file in csv format into database. This article guide you to do this step by step.
Oracle APEX Highlight a Record in Report – with Dynamic Action
![](https://orapedia.wordpress.com/wp-content/uploads/2013/02/alexnuijten.jpg?w=960)
Oracle APEX Highlight a Record in Report – with Dynamic Action
This article from Notes on Oracle
The article direct link APEX: Highlight a Record in Report – with Dynamic Action
Summary
In this article I want to show you how you can highlight a record in a report with a Dynamic Action. Why would you want to choose for a Dynamic Action? This is a more efficient way because you don’t need to refresh the page or the region.
Oracle APEX 4.0 Text Field with autocomplete
![](https://orapedia.wordpress.com/wp-content/uploads/2013/02/petervanderneut.jpg?w=960)
Oracle APEX 4.0 Text Field with autocomplete
This article from Whitehorses
The article direct link [Oracle APEX 4.0] Text Field with autocomplete
Summary
In previous APEX versions there is a lot of functionality you can add by simply incorporating some custom javascript. One example is a text field that shows an inline list of values for an item based on a query. Of course this is great functionality to provide to the user, but not that great for maintainability because of the custom code. APEX 4.0 now provides this functionality out of the box with the new item type Text Field with autocomplete.
Enhanced APEX Session Timeouts
![](https://orapedia.wordpress.com/wp-content/uploads/2013/01/martingiffydsouza.jpg?w=960)
Enhanced APEX Session Timeouts
This article from Martin Giffy D’Souza on Oracle APEX
The article direct link Enhanced APEX Session Timeouts
Summary
APEX has built in logic to set the lifetime of a session. To configure this option go to Shared Components / Edit Security Attributes / Maximum Session Idle Time in Seconds and set the time in seconds.
This essentially terminates the user’s session in the database and the next time they submit the page they’ll be redirected to the login screen. The user will only know that they are logged out once they submit the page. If you have an Interactive Report (IR), or use Partial Page Refresh (PPR) the users won’t know they’re logged out. Instead it will look as though the report is still trying to load.
Oracle Apex ALT-TAB: Better APEX Tabs [PDF]
![](https://orapedia.wordpress.com/wp-content/uploads/2013/02/sumneva.png?w=960)
ALT-TAB: Better APEX Tabs
This article from Sumneva
The article direct link ALT-TAB: Better APEX Tabs
Summary
Almost every APEX application ever written makes
use of some form of tabs
Why is this so?
Default option when creating an application
Tabs are a de-facto navigation control
“Easier” to use than
other types of navigation
controls
Why Not?
in this document you will find:
Overview
Alternative Tabs
jQuery UI
CSS Dropdown Menu Framework
APEX 4.0 UI Changes
Summary
you can download the ALT TAB Better APEX Tabs from the following link: