Forum Stats

  • 3,853,628 Users
  • 2,264,247 Discussions
  • 7,905,419 Comments

Discussions

Error when opening exported CSV file in EXCEL

581144
581144 Member Posts: 181
edited Oct 27, 2008 3:20AM in APEX Discussions
Hi,

I have a report which I would like to import into Excel. I have other reports in my application that imports to excel without any problems.

When I import the report into Excel I get the following result:

<div id="report_1082800291137941_catch"><pre>report error:
ORA-01722: invalid number</pre>

If I set the Use Query-Specific Column Names and Validate Query instead of Use Generic Column Names (parse query at runtime only) I get the following error when trying to apply the changes:

ORA-20001: Error getting query headings: ORA-06502: PL/SQL: numeric or value error
Error saving column settings.

Even throug I haven't made any changes to the query since I created it.

All the columns in my UNION query is of the same type.

Can anyone advice me?

Answers

  • Denes Kubicek
    Denes Kubicek Member Posts: 6,163 Bronze Crown
    I think you are mixing the words "export" and "import" and it is a bit hard to follow. Are you using the standard CSV export functionality of apex? Any chances to show your query? What if you run your query in SQL Workshop?

    Denes Kubicek
    -------------------------------------------------------------------
    http://deneskubicek.blogspot.com/
    http://www.opal-consulting.de/training
    http://apex.oracle.com/pls/otn/f?p=31517:1
    -------------------------------------------------------------------
This discussion has been closed.