Oracle经典自定义创建函数和存储过程

// 创建计算螺栓载荷的函数 create or replace function f_luoshuan_zaihe(d in number,b in number,m in number,p in number,q in number) return number is Result1 number; PI number :=3.14; begin Result1 := 0.785*(d-2*b)*(d-2*b)*p+2*PI*b*(d-2*b)*m*p+q; return Result1; exception when no_data_found then return 'error'; end f_luoshuan_zaihe; //创建存储过程，调用计算螺栓载荷的函数 create or replace procedure p_luoshuan_zaihe(d in number,b in number,m in number, p in number,q in number) is res number; begin select f_luoshuan_zaihe(d,b,m,p,q) into res from dual; dbms_output.put_line(sqlerrm); end p_luoshuan_zaihe;