Template List not correct at start

[jlathion]

Hello everybody,

I am currently trying to harmonize preferences within the company so that everybody is using and sharing the same kind of templates. We added the right path in preference file for TemplateDir.

In this template folder, we copied the standard PL/SQL developer templates and we added some of ours in sub-folders. My concern now is that at start of PL/SQL Developer, only the "standard" ones are shown. Our custom tempaltes are not appearing unless I right click on the template window and select Refresh List. Any idea about what I can do to ensure that the list is appearing properly at start ?

For information, I am currently using version 9.0.5.1648

Thanks in advance.

 

[Marco Kalter]

This seems to work fine for me. If you modify the preference within PL/SQL Developer, does this affect the problem?

 

[jlathion]

Hi Marco,

Sorry for the delay in giving you an answer on this but I was really busy with other stuff and put this on the side as we have a workaround.

I did some test today and noticed that the issue is happening because of the fact that I have two ini files for my preferences. One of them is applicable only to the development database (I have the following line in my preference file "Rules=*@[DB_ALIAS]"). The location of templates is stored in this file. And there is another set of preference that is applicable regardless of the connection.

I played with this property Rules to ensure that the first file is applicable before the other one. To summarize, I want the one which is limited to one connection to be the standard for all developers of the team. This file is being refreshed everytime PL/SQL is being launched to ensure that developers are all using the standard preferences that are applicable for our case. The other one is never overwritten and contains the preferences that are not standard and that developers can overwrite at will.

If I have only one file with restriction on a given connection or if I have no restriction on connection, it is working fine and template list is correct at start. But when I have the two files, then it is not showing the list properly without doing a refresh first.

Any idea about what could be the trouble ?

PS : I upgraded to version 10.0.5.1710 since my last post, but the problem is still there

 

[jlathion]

I still have this issue with template files due to multiple preference files. Any clue about the reason why it is not working ? Is there any chance to get this solved in a future version ?