Recent content by Jason McCleskey

Thanks Duncan. Unchecking the "Check compatibility when saving this workbook" in Excel does allow me to perform the save on my end as well. That's much better when exporting large datasets than the copy/paste option. Appreciate it! Problem resolved.

Agreed. It seems to be related to OneDrive trying to sync the file and not liking something. If I set it to export to a non-OneDrive directory there is of course no banner message at that point. Then if in Windows Explorer I copy the file over to a OneDrive directory it still shows up. So...

Correct on the semi-annual release channel. The 2008 date surprised me too but as you note in the MS note that's the way they version it. As for the PSD setting - yes - I have it set to Export XLSX format (Excel 2007 and higher). Screenshot attached for reference. Just for fun I toggled all...

Minor nuisance but any time we export to Excel via the "Copy To Excel" or "Export Results->Excel File" option we get banner stating "AUTOSAVE TURNED OFF This workbook contains features that prevent it from using AutoSave. Please save your workbook manually". If attempt to turn on AutoSave we...

Perfect! That is the type of solution I was looking for. Added this in the params.ini and now it is working without having to launch from a bat file. Thank you Marco! # Jason Customization # Add NLS_LANG setting here to override Windows 10 region settings nls_lang=american_america.utf8...

Good call! The environment variable lockdown is new here and I was surprised we couldn't hit our own user env vars. If I do as you note and open Start->type "environment" -> Choose "Edit environment variables for your account" that does allow me to set NLS_LANG as my own env variable. Too...

Thanks lost. But nope, didn't work. I have tried adding "SET NLS_LANG=AMERICAN_AMERICA.UTF8" in Login.sql and AfterConnect.sql (in the installation directory) and no change. Also added it in the "Initialization" tab on the Define Connections for the specific connection and it still doesn't...

Thank you both. Problem is due to corporate security we can't edit any Registry settings or environment variables (even user environment variables). We'd have to go through corporate security to have that done and honestly it's just easier to launch Pl/Sql Developer from my own bat file with...

Company recently switched from Toad to Pl/Sql Developer. Just encountered issue where a query with Chinese (or Japanese) characters issued from PSD does not return results but the same query executed from Toad (or Oracle Sql Developer) on same pc/database/oracle client works fine and returns...

Just a bump on this conversation to say I would like this too. My employer just recently licensed Pl/Sql Dev to replace Toad. One immediate nuisance is that the database we're in has many key ids that are 38 digits longs and we also export out to Excel a lot. If we check the "Number fields...