Bind variables do not retain their values when executing scripts. (4226154)

A script is executed in which some bind variable values are pass to a calling procedure as input parameters. These values do not reflect the values entered in the Bind Variable window.

For example, when the below script is executed, SQL Nav prompts user to enter values in the Bind Variable window. However, these values are not used in the script:

Declare
x Varchar2 (6) := Null;
y Integer := 0;
z Varchar2 (100) := Null;
Begin
x := :x;
y := :y;
temp.temp(x,y,z);
dbms_output.put_line (x || ' ==> ' || y || ' ' || z);
End;