SQL Window "Save as Standard Query" fails without error

[Roeland]

When I want to store my query using the "Save as Standard Query" of a SQL Window, and I use some unallowed characters, PL/SQL Developer fails to mention this...

I typed in the query name something with ":" and the query was not saved.

I did some more tests, but have now the problem that I don't know how to remove my tests?
Shift-Del should do the thrick, no?

PL/SQL Developer 12.0.1.1814 (64 bit)

 

[Marco Kalter]

You can only remove the files from the following directory:

%APPDATA%\PLSQL Developer 12\Standard Queries

We'll look into the error situation.

 

[Roeland]

I have noticed that those files are stored into
%APPDATA%\PLSQL Developer\Standard Queries instead of
%APPDATA%\PLSQL Developer 12\Standard Queries?

Is this a bug or a configuration issue?

 

[Marco Kalter]

I tested this, and they are saved under "PLSQL Developer 12" for me. Version 11 stored them under "PLSQL Developer". Can you verify?

Your original error report seems to be limited to the ":" character. When saving a file with a ":" in the name, it is truncated at the ":" position. For other invalid characters (such as "*" or "?") an error is displayed.

 

[Roeland]

I tested this, and they are saved under "PLSQL Developer 12" for me. Version 11 stored them under "PLSQL Developer". Can you verify?

I checked again, and the last change in the Standard Queries is from 19/10/2016 in the "PLSQL Developer 12" directory, while all my changes are stored into the "PLSQL Developer" one.
I then looked at the other directories where "PLSQL Developer" is used rather then "PLSQL Developer 12":

• PFInfo
• Red Gate Plug-In, allthough I don't use it

I checked the files, and this file is also updated in the wrong directory:

• PLSRecall.dat

 

[Marco Kalter]

Could it be that you have explicitly set the directory locations for these files in the preferences? Check the following preference pages:

Files > Directories
Files > Backup
Tools > Recall Statement

 

[Roeland]

That solved it. Thx Marco