Alexandr Ustinov
Member
Consider the code
In Command window and SQL Window it works fine, PSD ask for the &text value and substitutes is.
For Test Window it does not work - it asks nothing and just puts the &text into Output.
It will be nice to have True substitution behavior in Test window as well. Existing functionality implies that I need to use :text, but that is not true from SQL*Plus, ODAC and so on points of view (PSD's Command window as well), where & prefixed substitution variables are used instead of : ones.
Code:
declare
begin
dbms_output.put_line('&text');
end;
In Command window and SQL Window it works fine, PSD ask for the &text value and substitutes is.
For Test Window it does not work - it asks nothing and just puts the &text into Output.
It will be nice to have True substitution behavior in Test window as well. Existing functionality implies that I need to use :text, but that is not true from SQL*Plus, ODAC and so on points of view (PSD's Command window as well), where & prefixed substitution variables are used instead of : ones.