CREATE OR REPLACE PROCEDURE "PROCUDURE_NAME" (task_id NUMBER, deal_result out NUMBER, result_info out VARCHAR) AS BEGIN update TABLE_NAME set zzz ='z1' where ID = task_id; deal_result := 0; result_info := 'success'; END;