TOracleScript and substitution variables

[ldsandon]

In a script I have a statement like this:

sys.dbms_aq.enqueue(
  queue_name => '&ADMOWNER.ADM_FILES',
  enqueue_options =>  enqueue_options,
  message_properties => message_properties,
  payload => message,
  msgid => message_handle);

When I assign a value to &ADMOWNER, the dot after it disappears (i.e. if I set it to TEST I get TESTADM_FILES instead of TEST.ADM_FILES) as if the substituion code "eats" it. Is this a DOA bug? Using DOA 4.0.7.1 and Delphi 2006.

 

[ldsandon]

It works the same way in SQL*PLUS, therefore not a DOA issue - just wonder why it does work this way

 

[ldsandon]

Per SQLPLUS manual the dot is used to end the substitution variable if it it is not followed by a whitespace - very bad choice because the dot has a clear meaning within an identifier.
The solution is to use two dots.