Databases Reference
In-Depth Information
# in case of a Proxy
ProxyPass http://www.myserver.com:8080/apex
ProxyPassReverse http://www.myserver.com:8080/apex
</VirtualHost
With the following command you can verify if the host name and port are set correctly:
select owa_util.get_cgi_env('HTTP_HOST') from dual;
Flash Security Error
On some occasions you might receive the following error:
Flash Security Error:
AnyChart can not be launched due to Flash Security Settings violation.
Please refer to Security Error Article in AnyChart Documentation to fix this issue.
This error is linked to the previous error with the
#HOST#
, but this error is a more global security error
that any Flash object might have. You receive this error when the AnyChart SWF and the data for the
SWF are on a different domain. In some cases you might access APEX through one web server, while
your data comes from another. In this case the
#HOST#
is different if you use the standard way to generate
the XML for the chart, or you might have decided to call a procedure on another server, but this is
something that Flash doesn't allow unless you specify a cross-domain policy file. Another issue might be
that the SWF is loaded from http while the data comes from https.
The solution is, you use the same domain and protocol (http, https) or you tell Flash the other
domain is a trusted location. In the documentation of AnyChart you will find an example of a policy file
(AnyChart Documentation
- Implementation
- Security Error).
Charts in the Future
Charts are becoming more and more important in new websites and applications. They provide a quick
overview of a situation at any moment. Business Intelligence is already widely adopted, but having
charts in your APEX application gives you an advantage.
The charting world is rapidly changing. Column and bar charts have been around for a long time,
and will exist in the future, but as data grows exponentially, time-based charts become more and more
important. Being able to quickly navigate through a large volume of time-based data in a user-friendly
way will be a challenge. For example, AnyChart has created a new product called AnyStock, which allows
the creation of time-based and financial charts, but not all chart types are supported by the product yet.
Because applications need to run from anywhere and at anytime, Flash chart technology will
probably need a facelift. Adobe, the owner of Flash, is working hard to translate Flash objects on the fly
into native HTML5 code, which every future browser will be able to run. Flash is currently faced with the
issue that it doesn't run on devices that don't have or support a Flash plug-in, so a browser is not enough
to run these charts. As people expect to see and use their applications anywhere and anytime, non-Flash
charts will become more and more common in the future.
Other elements of the future of charting solutions will include user interaction like zooming, drag-
drop, different information depending on user interaction, and the like. Allowing the user to do things in
an innovative and intuitive way will become increasingly important and will decide if your application is
“wow”, or just okay.
We'll see how far Oracle will be able to follow these new charting trends in APEX, but it looks like
they intend to keep up with the future. Oracle has indicated that future versions of APEX will be able to
