PL/SQL stment

From: Tatireddy, Shrinivas (MED, Keane) <Shrinivas.Tatireddy_at_med.ge.com>
Date: Sat, 15 Sep 2001 21:16:02 -0700
Message-ID: <F001.0038FC96.20010915211517@fatcity.com>

Hi lists
the flwng

DECLARE
V_sal emp.sal%type;
BEGIN
SELECT sal
INTO v_sal
FROM emp
WHERE empno=&&p_empno;
IF v_sal<2000 then
UPDATE emp
SET sal=sal*1.2
WHERE empno=&p_empno;
END IF;
END; When I run the above, the first time the is asking the empno. But the next time I run it is taking the same old value what I previously gave.

I need to find out, where my old value is actually stored. and I need it to ask
 again for another value.

where my old value is actually stored?

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Tatireddy, Shrinivas (MED, Keane)   INET: Shrinivas.Tatireddy_at_med.ge.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Sat Sep 15 2001 - 23:16:02 CDT