Recent content by Delphist

There is a workaround. You can use API function SetEnvironmentVariable to change or set value of NLS_LANG variable. Environment variables have higher priority above registry setings. So you can get the result you need very simply.

Thank you for reply. But well you are not quite right, here is sample how to do it using buffer. var XLApp, XLSheet, wb, r : Variant; i, RowNo : integer; begin XLApp := CreateOleObject('Excel.Application'); wb := XLApp.WorkBooks.Add; XLApp.SheetsInNewWorkBook := 1; XLSheet :=...

Pl SQL Developer has problems with export. It does export cell by cell which takes a lot of time on big number of rows or big number of fields. Why don't you do export through temprorary buffer. Using buffer in 10 rows makes export in 100 times faster. I mean buffer is an array of variants.