一个简单pl/sql的例子

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

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

sql 代码

create or replace procedure pro_add_operation_log(
                  operation_name in sys_operation_log.operation_name%type,
                  operation_desc in sys_operation_log.operation_desc%type,
                  operator_name in sys_operation_log.operator_name%type,
                  operation_date in varchar2,
                  out_return out number,
                  out_error_msg out varchar) is

   SUCCESS NUMBER := 0;
   EXCEPTION_CALL_SP number:= -103;

begin
  insert into sys_operation_log(log_id,
                                operation_name,
                                operation_desc,
                                operator_name,
                                operation_date)
                                values
                                (seq_operation_log.nextval,
                                 operation_name,
                                 operation_desc,
                                 operator_name,
                                 to_date(operation_date,'YYYY-MM-DD HH24:MI:SS'));
   commit ;
   out_return:= SUCCESS;
exception
     when others then
          rollback;
          out_error_msg := 'encounter a exception,'||'sql code:'||sqlcode||'sqlerrm:'||sqlerrm;
          out_return:= EXCEPTION_CALL_SP;
end pro_add_operation_log;

分享到：

javaScript页面刷新 | Spring AOP实际应用一例

• 2007-08-01 17:24
• 浏览 1500
• 评论(0)
• 论坛回复 / 浏览 (0 / 2670)
• 分类:数据库
• 查看更多