Skip to Main Content

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Reading XML from Oracle directory to generate charts

cp29plusJul 17 2013

Hi,

I have a requirement create graphs, charts and maps based on data from a data warehouse (dw).  As I see things, there are two possibilities:

  • Graphs, charts and maps based on an XML file
  • Graphs, charts and maps based on Oracle tables

Both would contain small data sets that will allow for quick response.  The intent of these graphs, charts and maps is to generate a dashboard that would allow the user to quickly drill down to the desired warehouse data.

The proof of concept has already been validated using the Oracle table scenario.  My question is whether or not this could be accomplished reading xml files for generating the same set of dashboard items?

My Oracle database and APEX environments configuration are as follows:

NLSRTL                 11.2.0.1.0                                                           Production
Oracle Database 11g Enterprise Edition 11.2.0.1.0                         64bit Production
PL/SQL 11.2.0.1.0                                                                            Production
TNS for Solaris: 11.2.0.1.0                                                               Production

Application Express 4.2.2.00.11

APEX Listener Release 2.0.2.  / Tomcat

An Oracle database directory has been setup and is accessible to our APEX application.

Any suggestions/help is appreciated.

Thanks,

Charles

Comments

Processing
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Aug 14 2013
Added on Jul 17 2013
0 comments
258 views