-
In order for Oracle APEX Flash Charts to work, you would need a crossdomain.xml file placed in the root folder of your virtualhost.
<?xml version="1.0"?>
<!DOCTYPE cross-domain-policy SYSTEM "http://www.macromedia.com/xml/dtds/cross-domain-policy.dtd">
<cross-domain-policy>
<allow-access-from domain="*" />
</cross-domain-policy>
For more details on how to have a stricter crossdomain policy, visit Adobe Developer Site .
But when you are using Apache2 as a reverse proxy, you could be having another problem.
Read More
-
As you probably know, Oracle 10g XE database does not provide the utl_mail package. So, in order to send e-mails from the database, you would have to use utl_smtp and write your own mail package. I found various solutions on the web but I had a major problem. Greek language in the mail subject and text. So I have made some adaptations to the code to support UTF-8 'message' and 'subject' text.
Read More
-
Started evaluating the performance of a production system as a new project we undertook. APEX pages were slow to load, responsiveness was also slow. After some research, we found out that WWV_FLOW_DATA table had 732 million rows and WWV_FLOW_SESSIONS$ had 193 million rows (APEX_040200 schema). The cause: someone had droppped the scheduled job ORACLE_APEX_PURGE_SESSIONS!
Read More
-
There are multiple articles on the web about how to configure Oracle Apex 4 on Oracle 10g XE and Apache2. The basic setup that is you use the Apache2 as a Proxy to serve the Oracle EPG Gateway pages, compressing text with mod_deflate, setting expiry headers for images with mod_expires and restricting access to APEX administration using mod_rewrite.
Read More