Problem with update inside a procedure
Date: 20 Feb 2002 11:40:24 -0800
Message-ID: <33ea13eb.0202201140.9ea0c73_at_posting.google.com>
I have wrote a simple procedure to update 2 fields in a table. The
problem is only one field (MEASUREMENT) get updated but the other
field (TIME_STAMP) is ignored. It works when I manually run the same
update statement in SQL/PLUS. Any help is appreciated.
-Leo
CREATE OR REPLACE procedure CREATE_TELEMETRY (ptvID IN NUMBER,
INSERT INTO TELEMETRY (PTV_ID, TIME_STAMP, MEASUREMENT)
VALUES (ptvID, time_stamp, value);
value IN NUMBER, time_stamp IN NUMBER)
IS
c NUMBER ;
BEGIN
SELECT count(*) INTO c FROM TELEMETRY_LATEST WHERE PTV_ID=ptvID;
INSERT INTO TELEMETRY_LATEST (PTV_ID, TIME_STAMP, MEASUREMENT)
VALUES (ptvID, time_stamp, value);
END IF;
END CREATE_TELEMETRY;
/
Received on Wed Feb 20 2002 - 20:40:24 CET