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;
WORKAROUND:
Re-execute the script for a second time.
STATUS:
Waiting for fix to be released in a future version of SQL Navigator for Oracle.
