Databases Reference
In-Depth Information
AnyChart to make sure every call is unique, otherwise the browser might cache the result and you might
get incorrect results. You don't have to do anything special for that—AnyChart handles everything for
you. You just need to make sure you accept these extra parameters in your procedure. The procedure
looks like this:
create or replace procedure get_dashboard_xml_prc(
p_param1 varchar2 default null,
XMLCallDate IN NUMBER DEFAULT NULL)
is
-- limit of 32K in single byte characterset, for UTF8 devide by 4 -1
l_amt number default 8191;
l_offset number default 1;
l_length number default 0;
l_chart clob;
l_chart_v varchar2(32767);
l_chart_data clob;
begin
dbms_lob.createtemporary( l_chart, FALSE, dbms_lob.session );
dbms_lob.open( l_chart, dbms_lob.lob_readwrite );
l_chart_v := '<anychart>
<settings>
<animation enabled="True"/>
</settings>
<dashboard>
<view type="Dashboard">
<title padding="2">
<text>USA Sales Map</text>
</title>
<background>
<inside_margin all="3" top="10"/>
</background>
<vbox width="100%" height="100%">
<margin all="0"/>
<hbox width="100%" height="60%">
<margin all="0"/>
<view type="Chart" source="mapChart" width="100%" height="100%"/>
</hbox>
<hbox width="100%" height="40%">
<margin all="0"/>
<view name="productsView" type="Chart" source="productsChart"
width="50%" height="100%"/>
<view name="personsView" type="Chart" source="personsChart"
width="50%" height="100%"/>
</hbox>
</vbox>
</view>
</dashboard>
<charts>
<chart plot_type="Map" name="mapChart">
<chart_settings>
