| |
|
A Little About Jason Bennett ...
I've had an interest in publishing technical articles and HELPFUL code for a few years. I am (by trade and hobby) a developer who specializes in Oracle technologies and web based architectures. I have been an employee of both TUSC and Oracle Corporation. My intent here is to share my ideas and coding experiences with the developer community as a whole. As with all developers some of my ideas are great and some of them are .... well you know. Anyway, I hope you find something here that will aid in your endeavor, or spark a new idea.
I am more than happy to assist with technical issues and will even write a little code if need be. If you find something on the site that is really useful and you'd like to make a contribution (absolutely up to you and absolutely not required), just click the "Make a Donation" button on the left!
Good luck and good coding ! |
|
|
|
Friday, May 01, 2009
|
|
Generate FusionCharts Free Flash Charts with Oracle PL/SQL
Since Flash charts have become the norm for delivering visual data to our endusers in a browser based environment, I thought it would be cool to create a method for delivering both the physical flash object and the dataset for that chart straight from the database using PL/SQL. I chose a product called FusionCharts Free (http://www.fusioncharts.com/free/) as my Flash chart (binary object) provider. FusionCharts Free comes with 22 fully functional (free) charts of varying types from the basic charts to combination charts in both 2D and 3D formats. Each chart type requires a specifically formatted XML data set. The PL/SQL API I have developed makes it easy for a developer to store and deploy these flash charts directly from the Oracle database and to create dynamic data sets for each chart type directly from the database. Even though the API allows for "one stop shopping" with regard to chart object loading and data set generation, developers can also use this API solely for data set generation. This makes it easy to integrate data from Oracle databases into existing applications that use FusionCharts Free.
For complete PL/SQL API documentation including sample code, see the following document (opens in new window):Generate Flash Charts with PLSQL
The PL/SQL API can be downloaded here:FusionChartsPLSQL.zip
FusionCharts Free can be downloaded here:FusionCharts Free
The following chart was generated using the PL/SQL API. Everything from rendering the HTML to streaming the Flash Object to generating the XML data set was accomplished using the API :
 The same chart embedded in an Oracle APEX page Report Region (Dynamic PL/SQL Region):
As with all of my code, please feel free to contact me with questions.
2:39:50 PM 
|
|
 |
© Copyright 2009Jason Bennett.
Last update: 6/19/2009; 10:56:24 AM. |
|
| May 2009 |
| Sun |
Mon |
Tue |
Wed |
Thu |
Fri |
Sat |
| |
|
|
|
|
1 |
2 |
| 3 |
4 |
5 |
6 |
7 |
8 |
9 |
| 10 |
11 |
12 |
13 |
14 |
15 |
16 |
| 17 |
18 |
19 |
20 |
21 |
22 |
23 |
| 24 |
25 |
26 |
27 |
28 |
29 |
30 |
| 31 |
|
|
|
|
|
|
| Mar Jun |
| |
