BI-TAGS

# cd /etc/yum.repos.d # wget http://public-yum.oracle.com/public-yum-el5.repo

Open the yum configuration file in a text editor Locate the section in the file for the repository you plan to update from, e.g. [el4_u6_base] Change enabled=0 to enabled=1

@apexins.sql SYSAUX SYSAUX TEMP /i/

@apxchpwd.sql

Shut down with normal or immediate priority the Oracle Database instances where you plan to install Oracle Application Express.

All of which led me to FusionCharts, which is a brilliant set of flash charts and widgets.

All I had to do was figure out how to integrate it into my app. First I had to write a function to extract the data I needed from my database and output it as correctly-formatted XML. That bit was easy so I won't bore you with it.

Next I uploaded the Flash (SWF) file for my chart into my workspace. (Tell me something: when you upload an image to your application using Apex's image uploader you refer to it by pointing at # APP_IMAGES#, so how do you think you'd refer to a file you've uploaded using Apex's file uploader? #APP_FILES#? Wrong! Illogically, all files uploaded into your application should be pointed at using the #APP_IMAGES# substitution string.)Finally, I created a dynamic PL/SQL content region outputting the necessary wrapper tags for my Flash movie (which I copied from the FusionCharts examples), pointing it to my uploaded swf file and feeding it the XML from my database function (which I call in "before regions" page process).

sudo su

/etc/init.d/apparmor stop update-rc.d -f apparmor remove apt-get remove apparmor apparmor-utils

groupadd mysql useradd -r -g mysql mysql