Re: Problem with update inside a procedure

i think it's because the parameter name in your proc is the same as the table's column_name ..

leo_at_6d.com (Leo) wrote in message news:<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,
> 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 (PTV_ID, TIME_STAMP, MEASUREMENT)
> VALUES (ptvID, time_stamp, value);
>
> -- update TELEMETRY_LATEST
> IF c > 0 THEN
> UPDATE TELEMETRY_LATEST set
> TIME_STAMP = time_stamp,
> MEASUREMENT = value
> WHERE PTV_ID=ptvID ;
> ELSE
> 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 - 22:40:39 CET