Error when opening exported CSV file in EXCEL

581144

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?

Denes Kubicek

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
-------------------------------------------------------------------