tomlogic

Can i use the bind variable inside a procedure?
and the query like update emp set empname=:name where empno=:no;

but i work like update emp set empname=&name where empno=&no inside procedures it works properly

Code: ( text )
declare
i number:=0;
begin
while i<3
loop
update dept set empno=&empno where dname=’&deptname’;
i:=i+1;
end loop;
end;