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;
© ALL RIGHTS RESERVED. Feedback 이용 약관 개인정보 보호정책 Cookie Preference Center