Hello folks.
As the title says, I'm hitting the ORA-01882 error, both on SQL Developer and SQLCL. Did some research and found many info about this situation and how this is a java problem rather than a database issue.
It was easy to find a solution for SQL Developer, just needed to add AddVMOption -Doracle.jdbc.timezoneAsRegion=false to the sqldeveloper.conf file and it worked like a charm.
Logically, since sqlcl is also based on java, this should be the same solution, right? Only problem is that sqlcl does not have a conf file.
I found an old post here in the forum (https://forums.oracle.com/ords/apexds/post/ora-01882-timezone-region-not-found-on-sqlcl-6634#comment_323462165725900199915802481891662801769) with the exactly same problem. But the solution is no longer applicable: the person added the -Doracle.jdbc.timezoneAsRegion=false option to a .bat file, but I believe the .bat file was ditched in favor of the actual exe nowadays.
I tried calling the sql.exe with the said option, but it does not work; It seems the compiled exe file does not accept java parameters as options?
So, Mr. Jeff Smith, any idea on how to solve this problem?