Double Ampersand in Code - Compilation and Beautifier Problem

[sabine22]

Hello,

I was very happy to find PL/SQL Developer at my customer's site.
But I am struggling with the following problem:
Our scripts make extensive use of double ampersands like in this example:

CREATE OR REPLACE PACKAGE &&DBUSER..pkg_dummy IS

PROCEDURE dummy;

END pkg_dummy;

As PL/SQL Developer does not recognise this, it is not substituted, and then the compiler complains about it.
The Beautifier doesn't recognise this either, and transforms it to

CREATE OR REPLACE PACKAGE &&DBUSER .. pkg_dummy IS

PROCEDURE dummy;

END pkg_dummy;

What can I do about it? Any settings that will help?

The version I am using is 7.1.5.

Many thanks in advance!
Sabine

 

[Marco Kalter]

Substitution variables are supported, but unfortunately not with a double ampersand. So this would work:

CREATE OR REPLACE PACKAGE &DBUSER..pkg_dummy IS

Press the & button on the status line to define the value.

I have added support for && to the list of enhancement requests.

 

[sabine22]

Thanks Marco.

Does anyone have an idea for a workaround?
It's a bit dangerous to rely on the user to change it back before checking in...

Best regards,
Sabine