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!
For example, let's say I ran an extract twice, once for May 1 and again for June 1. If I want to start over with how the data looked before I ran it on May 1, could I roll back the extract twice?
Denes: Very nice.
Few questions, if you don't mind.
chart_template_in => 'SERIES_SWITCH_1,DECIMAL_CHART_VALUE',
1. What determines the overall look and feel of the generated chart? Is it the XML file you show? 2. If so, where does that XML file live? In a Oracle DIRECTORY on the server? 3. What does the above IN parameter to your procedure do? Why are there 2 values to the parameter?
[Sorry if I am missing something basic about all this, my charting experience is close to zero]
Thanks
SQL>show error package body Xml_Chart_Pkg Errors for PACKAGE BODY XML_CHART_PKG: LINE/COL ERROR -------- ----------------------------------------------------------------- 95/19 PL/SQL: SQL Statement ignored 98/46 PL/SQL: ORA-00942: table or view does not exist 105/13 PL/SQL: Statement ignored 105/34 PLS-00364: loop index variable 'C' use is invalid 106/13 PL/SQL: Statement ignored 109/24 PLS-00364: loop index variable 'C' use is invalid 130/22 PL/SQL: SQL Statement ignored 133/49 PL/SQL: ORA-00942: table or view does not exist 141/16 PL/SQL: Statement ignored 141/37 PLS-00364: loop index variable 'C' use is invalid 143/16 PL/SQL: Statement ignored 144/57 PLS-00364: loop index variable 'C' use is invalid 146/25 PL/SQL: SQL Statement ignored 162/43 PL/SQL: ORA-00942: table or view does not exist 168/19 PL/SQL: Statement ignored 169/57 PLS-00364: loop index variable 'D' use is invalid 170/19 PL/SQL: Statement ignored 170/40 PLS-00364: loop index variable 'D' use is invalid 181/22 PL/SQL: SQL Statement ignored 184/49 PL/SQL: ORA-00942: table or view does not exist SQL>
O.K.
Here is the explanation for the package parameters:
BEGIN xml_chart_pkg.xml_chart_pr (item_for_query => ':P1_ITEM', --item storing your chart query chart_type_in => 'stacked', --your chart type sort_series_in => 'ASC', --how to sort series width_in => 600, --width of your region height_in => 450, --height of your region debug_xml_in => 'N', --using debug option xml_output_dir_name_in => 'DIRECTORY', --debug output directory chart_template_in => 'MY_TEMPLATE:SWITCH_COLORS', --templates to be used with your chart chart_standard_ignore_in => 'N', --ignore all standard settings link_type_in => 'P', --link type P for popup and R for redirect page_to_pass_values_to => '200', --page to pass values in the link request_in => 'SORT', --request to pass within link items_to_pass_values_to => 'P200_ITEM', --items to pass values to, comma delimited values_to_pass_to_items => '_category_', --values to pass to items, see XML reference link_pop_up_w_in => '1000', --link popup window width link_pop_up_h_in => '800', --link popup window height chart_background_color_in => '#ededd6', --region color unique_id_in => NULL, --unique string to identify your chart if the same chart --type is used on the same page turn_caching_on => 'N' --if your want to keep the session result per chart, --use collection to store the result set ); END;
item_for_query is the only parameter without a default option - means you need to specify only this one.
Denes Kubicek