Path: news.easynews.com!newsfeed1.easynews.com!easynews.com!easynews!news.he.net!news-hog.berkeley.edu!ucberkeley!newsfeed.stanford.edu!postnews1.google.com!not-for-mail
From: bxgoldshmidt@johncrane.com (Boris Goldshmidt)
Newsgroups: comp.databases.oracle.server
Subject: Equivalent to UNDEFINE in PL/SQL
Date: 10 Oct 2002 10:45:04 -0700
Organization: http://groups.google.com/
Lines: 24
Message-ID: <88c2cc28.0210100945.45f31949@posting.google.com>
NNTP-Posting-Host: 209.48.107.195
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 8bit
X-Trace: posting.google.com 1034271905 7304 127.0.0.1 (10 Oct 2002 17:45:05 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: 10 Oct 2002 17:45:05 GMT
Xref: newsfeed1.easynews.com comp.databases.oracle.server:163755
X-Received-Date: Thu, 10 Oct 2002 10:45:00 MST (news.easynews.com)

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;
/