Replacement variables (&) not being replaced in command window

[KristerL]

Hi,

When I install a file in a Command window and a view is created, when a comment is added to a column, the replacement variables are not replaced with the defined value. E.g.

DEFINE PKG = TEST_API

in a view column comment:

comment on column MY_VIEW.TEST_COLUMN is 'REFERENCE=:&PKG..Get_Default_Test_Value';

In previous versions of PL/SQL developer "&PKG.." was replaced with "TEST_API.".

I recently upgraded from 8 to 10, so I guess something has changed in between as this has previously worked since version 3 or so.

Is this a bug, intended behaviour or is there perhaps a setting I have missed somewhere?

Thanks,
Krister

 

[Marco Kalter]

This works fine for me. Which PL/SQL Developer version are you using?

 

[KristerL]

My version is 10.0.4.

I think I have found the issue. The example I gave was a simplified version and was missing some parts.

If you instead use this line:

comment on column MY_VIEW.TEST_COLUMN is 'FLAGS=--^REFERENCE=:&PKG..Get_Default_Test_Value';

If there are two hyphens (--) inside the comment string and to the left of the &, it looks like the &PKG is not expanded to the package name.

I double-checked with Sql*Plus, and in there it installs correctly.

 

[Marco Kalter]

This does indeed reproduce the issue. We'll fix this parser bug.