What does the command
return just before you call the Pro*C program? Note, enter the command exactly as shown above.
i have put the the command exactly one line before the call of pro c progrmme
I am printing the oracle table content into flat file like
EXEC SQL BEGIN DECLARE SECTION;
EXEC SQL END DECLARE SECTION;
EXEC SQL PREPARE S FROM :sqlstmtnv;
EXEC SQL DECLARE C CURSOR FOR S;
EXEC SQL OPEN C;
fp_outputnv = fopen(out_filenv,"w");
EXEC SQL FETCH C INTO :commandnv; /* i am skipping some looping or clarity */
fprintf(fp_outputnv, "%s\n", (char *)commandnv.arr);
My OS admin just replied back that he changed the NLS_LANG=AMERICAN_UNITED KINGDOM.WE8ISO8859P15 which didnt get reflected in CHARACTER CONVERSION till the restart of pro*C programme. which runs as daemon process .
This issue is now resolved.
Thank you for helping me out to find how to get a confirmation what NLS_LANG was set in production and what the proc*c programme would be used. much appreciated for the ASAP reply on my concern;
You are welcome.
Please be aware that your NLS_LANG should match the expected character set of the produced files. If the files are to be displayed on Windows workstation, then the character set should be WE8MSWIN1252, as this is the character set that the Windows GUI expects. With WE8ISO8859P15, the Euro sign will be incorrectly displayed as the currency sign (¤).