RE: PL/SQL stment

From: Ramon Estevez <com.banilejas_at_codetel.net.do>
Date: Mon, 17 Sep 2001 06:09:38 -0700
Message-ID: <F001.0039033D.20010917053518@fatcity.com>

Remove one ampersand.
WHERE empno=&p_empno

Ramon E. Estevez
com.banilejas_at_codetel.net.do <mailto:com.banilejas_at_codetel.net.do> 809-565-3121

-----Mensaje original-----
De: root_at_fatcity.com [mailto:root_at_fatcity.com]En nombre de Tatireddy, Shrinivas (MED, Keane)
Enviado el: Sunday, 16 September, 2001 12:15 AM Para: Multiple recipients of list ORACLE-L Asunto: PL/SQL stment

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).

--

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

Author: Ramon Estevez
INET: com.banilejas_at_codetel.net.do

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