一个简单pl/sql的例子

第一次用存储过程，总结一下今天写的第一个存储过程

该存储过程主要实现简单插入操作

sql 代码

1. create or replace procedure pro_add_operation_log(   
2.                   operation_name in sys_operation_log.operation_name%type,   
3.                   operation_desc in sys_operation_log.operation_desc%type,   
4.                   operator_name in sys_operation_log.operator_name%type,   
5.                   operation_date in varchar2,   
6.                   out_return out number,   
7.                   out_error_msg out varchar) is  
8.               
9.    SUCCESS NUMBER := 0;   
10.    EXCEPTION_CALL_SP number:= -103;           
11.                            
12. begin  
13.   insert into sys_operation_log(log_id,    
14.                                 operation_name,     
15.                                 operation_desc,    
16.                                 operator_name,   
17.                                 operation_date)    
18.                                 values  
19.                                 (seq_operation_log.nextval,   
20.                                  operation_name,   
21.                                  operation_desc,   
22.                                  operator_name,   
23.                                  to_date(operation_date,'YYYY-MM-DD HH24:MI:SS'));   
24.    commit ;   
25.    out_return:= SUCCESS;   
26. exception   
27.      when others then  
28.           rollback;   
29.           out_error_msg := 'encounter a exception,'||'sql code:'||sqlcode||'sqlerrm:'||sqlerrm;   
30.           out_return:= EXCEPTION_CALL_SP;   
31. end pro_add_operation_log;