Is there an equivalent to "UNDEFINE" command in PL/SQL? In the
example below, I am trying to update col1 based on user input. The
issue is that, variables i1 and i2 will not prompt the user for input
after the the first pass. How can I undefine these variables and
prompt the user for new input inside the loop? Thanks for your help.
UNDEFINE i1 i2
DECLARE v1 NUMBER :=0;
v2 NUMBER :=0;
cnt NUMBER :=0;
BEGIN
LOOP
cnt := cnt+1;
v1 := &i1;
v2 := &i2;
UPDATE ex1
SET col1=v1
WHERE col2=v2;
EXIT WHEN cnt=12;
END LOOP;
COMMIT;
END;
/
Received on Thu Oct 10 2002 - 12:45:04 CDT
