4 Replies Latest reply: Dec 9, 2009 4:20 AM by Z? RSS

    FLOW_EXCEL_OUTPUT_R error in the downloaded csv file

    628828
      Hello,
      I'm trying to use the functionality of the FLOW_EXCEL_OUTPUT_R as follows:

      href="f?p=&APP_ID.:14:&SESSION.:FLOW_EXCEL_OUTPUT_R&P_REGION_ID._en"

      Where the computation for P_REGION_ID is:
      SELECT region_id  FROM apex_application_page_regions
      WHERE        application_id = :app_id
      AND page_id = :app_page_id
      AND region_name = 'CSV export'

      In the downloaded CSV file i get the following:
      - the first row: +<||div id="report_33994800669487811_catch">+
      - the last 2 row: +<||pre>report error:+
      ORA-06502: PL/SQL: numeric or value error: character to number conversion error<||/pre>
      (|| - sign is so I can show the tags in the post)
      The rest of the data is downloaded ok.
      But still how can i get rid of these errors?
      Thanks,
      Adela