oracle存贮过程示例

CREATE OR REPLACE PROCEDURE ModeTest(  p_InParm IN NUMBER,  p_OutParm OUT NUMBER,  
p_InOutParm IN OUT NUMBER)  IS  
v_LocalVar NUMBER; /* 声明部分 */  BEGIN  
v_LocalVar:=p_InParm; /* 执行部分 */  p_OutParm:=7;  p_InOutParm:=7;  ...  
EXCEPTION  
... /* 异常处理部分 */  END ModeTest;