SQL*Plus SPOOL on the windows command line

Question

I have a problem with the command SPOOL of SQL*Plus executed on an UNIX system...

Before connecting to the database with SQL*Plus, I do an :

export NLS_LANG=french_FRANCE.UTF8

Then :

spool EXCEPTION.csv
select MY_COLUMN||';'||EXCEPTION_MESSAGE from TABLE_EXCEPTION;
spool off

When I open EXCEPTION.csv with Notepad++ on Windows :

ORA-01403: aucune donnée trouvée

It's what I expected, but with Microsoft Excel :

ORA-01403: aucune donnÃ©e trouvÃ©e

So, is it possible to SPOOL to the command line with SQL*Plus, without having to make an unix2dos EXCEPTION.csv ?

score 1 · Accepted Answer · edited May 23 '17 at 12:27

1

You have an encoding problem.

First you can try to set encoding in spool part. See this question.

Second you can try to choose correct encoding in Text Import wizard. That is instead of double clicking file name.

Open blank excel sheet
Choose Data Tab
Choose Import txt file.
Choose correct encoding

Import Text Text Import Wizard

edited May 23 '17 at 12:27

Community

1
1

answered Nov 18 '14 at 10:07

Atilla Ozgur

14,339
3
49
69

Thanks. But is it possible to define the file encoding during the spool ? – BnJ Nov 18 '14 at 10:18

score 0 · Answer 2 · answered Nov 25 '14 at 20:20

Encoding is also done via FTP. So, in addition to the above (edit: below), behold the option to copy as ASCII/TEXT or BINARY. These 2 methods should end up with different files. Optionally, your FTP tool can also use additional text conversion options, which are done when using ASCII/TEXT method.

SQL*Plus SPOOL on the windows command line

2 Answers2