Hi Experts-
We are spooling the data like shown below which consists of french text retrieved from a select query into a text file from a sql file, and we are executing that .sql file from unix.
Strangely when we execute that .sql file from my colleagues machine connecting to the same unix server with the same credentials the french text(with all the special characters) is being spooled, however it is not happening (all the special characters are disappeared) from any other machine ( same unix server with the same credentials).
SET ARRAY 4000
SET TERM OFF
SET WRAP OFF
SET FLUSH OFF
SET TAB OFF
SET HEAD OFF
SET VERIFY OFF
SET TAB OFF
SET FEEDBACK OFF
SET PAGESIZE 0
SET LINESIZE 1999
SET TRIMSPOOL ON
SET TRIMOUT ON
SPOOL %path%
SELECT * FROM TEMP_TABLE;
SPOOL OFF
I don't see any difference.
Please let me know what I need to check to make sure it works from every machine, or any thing I can do to get those special characters while spooling.
Thank you,
Pradeep