oracle创建存储过程

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;
原文地址:https://www.cnblogs.com/white-knight/p/8649646.html