PL/SQL Developer Variables

[he]

Hello

the variables are a very useful feature inPL/SQL Developer. Unfortunately they work only in a SQL Window. In a Test Window it is not possible to use the variables, because it appears a ORA-06550 error.

But is is possible to write a PL/SQL Script with variables in a Test Window, then copy&paste it in a SQL Window and then the script works.

Please try the following code in SQL Window and Test Window:

declare
  v_strSearch varchar2(2000);
begin
  select &<name="Search"
           hint="Text to find"
           type="string"
           required="yes"> into v_strSearch from dual;

  dbms_output.put_line(v_strSearch);
end;

Please make the variables work in all circumstances.

Thanks
he

 

[Marco Kalter]

I have added this to the list of enhancement requests.