How to call update query in procedure of oracle

Question

hello friends

I have one table, t1, which has fileds called userid, week and year fields. I want to call a procedure which takes all three values as arguments and fires an update query. How can i do it?

My update query should be like

update t1 
    set week = (value of procedure argument) 
        , year = (value of procedure argument)
 where userid=(value of procedure argument);

Answer 1

You can do something like this:

CREATE OR REPLACE PROCEDURE my_update_proc (w number, y number, u number) IS
BEGIN
   UPDATE t1
   SET    week = w,
          year = y
   WHERE  userid = u;
   COMMIT;
END my_update_proc;
/

Update: As @Rene has correctly pointed out, you probably do not want to have a COMMIT statement in your stored procedure. If you remove it, however, the caller must remember to commit the transaction.