Autoreplace, Templates and Projects

[Roeland]

Hi,

I have made a file "Begin.tpl" for Autoreplace and placed it in the PL/SQL application directory (also the same directory where the Autoreplace Definition File (=AutoReplace.txt) is placed)

The corresponding line in my AutoReplace.txt is like this:

...
b = begin.tpl
...

Code for the Begin.tpl:

begin
  [#]
end ;

This template worked like a charm until some days ago I started to use Projects.
After a while when typing 'b' the template isn't executed anymore but I get the text "Begin.tpl" instead (just like a string replace)

Version 7.1.5.1397
Windows 2000 Professional 5.0 Build 2195 (Service Pack 4)

Note that the Project is stored in a different directory.

Any ideas?

Roeland

 

[Marco Kalter]

I cannot reproduce this. Are the AutoReplace definitions still okay?

 

[Roeland]

Are the AutoReplace definitions still okay?

Yes, when I restart PL/SQL developer everything works as usual.

It happens after working multiple hours...
I can't reproduce it on the fly.

I had never noticed it before, but since I'm working with Projects (one week) I have seen this already multiple times.

Could the reason be that my project is located in another directory?

Roeland

 

[Marco Kalter]

Could the reason be that my project is located in another directory?

I doubt it. There is no direct relation between Projects and AutoReplace. We'll check it out though.

 

[oleg_dov]

Hi!
Have same problem on all versions of pl\sql developer, which I tried to use.
I've install 8 beta. Same problem, but I can't connect it to project functionality and my paths are different:

s=Template\AutoReplace\select.tpl
sd=Template\AutoReplace\select_dual.tpl
sc=Template\AutoReplace\select_count_from.tpl
ss=Template\DML statements\Select.tpl
b=Template\AutoReplace\begin_end.tpl
be=Template\Error handling\Exception block.tpl

Finally I tried to resolve this problem and solution is following (for my case):

s=..\Template\AutoReplace\select.tpl
sd=..\Template\AutoReplace\select_dual.tpl
sc=..\Template\AutoReplace\select_count_from.tpl
ss=..\Template\DML statements\Select.tpl
b=..\Template\AutoReplace\begin_end.tpl
be=..\Template\Error handling\Exception block.tpl

And it works without restarting of PL\SQL Developer, just need to open new sql window.
I think that problem in paths - application lost it some how.

Thanks

 

[Marco Kalter]

You should remove the Template directory reference, since this is the starting point:

s=AutoReplace\select.tpl
sd=AutoReplace\select_dual.tpl
sc=AutoReplace\select_count_from.tpl
ss=DML statements\Select.tpl
b=AutoReplace\begin_end.tpl
be=Error handling\Exception block.tpl

 

[oleg_dov]

Ok thanks I will change it.