I noticed in a procedure I was working on today that if I pass in a value that has a dot in it for a VARCHAR2 input parameter, it does not add quotes around the value in the generated PL/SQL:
This is a problem for my use case, as the input in question is a timestamp string, which in the default SQL developer format has dots between the hour, minute, and second values.
Sure, I can still make it work if I modify the generated PL/SQL in the window before hitting OK to run it, but that's not really an acceptable repeatable case. Or I could modify the SQL Developer NLS settings to not use dots between those values, but I can't ask everyone in my office to change their SQL Developer settings just to accommodate this one stored procedure.
Has anyone else noticed this? Has this been reported as an issue? I am running the most recent version of SQL Developer (20.2.0.175, Build 175.1842), but I also had tried 18.4.0 (what I started working on this on before jumping to the new version hoping for better results).