Variables substitution in templates

[Aviga]

Hello,

I use a template file containing this SQL query:

select name from v$database;

Whenever I create a new window using this template, "$database" is replaced by the value of the current database.

I tried using v$$database, but then this is "$$database" which is replaced by the database's name.

Thanks for your help.

Regards,

Avigael

 

[Marco Kalter]

Can you show me the complete template text?

 

[Aviga]

Hello,

I sent you the template file in a separate email addressed to the support.

I couldn't copy/paste it here.

Regards

Avigael

 

[Marco Kalter]

I received it, and it works fine after replacing v$database with v$$database. I will send you some screenshots by e-mail.

 

[Aviga]

Hi Marco,

That's really strange. I followed your steps and they do work on my installation.

I had tried not to create a new template but to modify the existing template, both inside and outside PL/SQL Developer.
Another difference is that I opened a new window rather than inserted the text of the template inside an existing command window.

What I don't understand, is that I re-tried the previous steps (modify the original template + open a new window), and now... this works.

I thought this could have been linked with my login.sql script, but I didn't update it before testing again.

So, everything is fine now. Not the first mystery in IT...

Thanks a lot for your help.

Regards

Avigael