RE: PL/SQL stment

[Ramon Estevez]

Remove one ampersand.
WHERE empno=p_empno

Ramon E. Estevez
[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] 
809-565-3121


-Mensaje original-
De: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]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_sal2000 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: [EMAIL PROTECTED]

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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED]

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: [EMAIL PROTECTED] (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).

Re: PL/SQL stment

[Konrad BKo]

Hi

Make define p_empno in the header of script and undefine in the end then
it's work's !

Regards

- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Sunday, September 16, 2001 7:15 AM


 Hi lists
 the flwng

 DECLARE
 V_sal emp.sal%type;
 BEGIN
 SELECT sal
 INTO v_sal
 FROM emp
 WHERE empno=p_empno;
 IF v_sal2000 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: [EMAIL PROTECTED]

 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: [EMAIL PROTECTED] (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: =?Windows-1252?Q?Konrad_B=FCKo?=
  INET: [EMAIL PROTECTED]

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: [EMAIL PROTECTED] (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).