create or replace procedure testABC(inParam in varchar2,
outParam out varchar2) as
ipCount number;
begin
select count(*)
into ipCount
from (select distinct rs.ip from ip_table rs);
outParam := inParam;
dbms_output.put_line('输入:'||inParam||',输出:'||outParam||',IP值:'|| ipCount);
insert into abc_table(id, count) values (seq_abc.nextval, ipCount);
commit;
exception
when others then
rollback;
--截获具体异常,记录日志
insert into PLSQL_LOG_table
(id, Pro_Name, Gmt_Create, ERROR_MSG)
values
(seq_plsql_log.nextval,
'testABC',
sysdate,
substr(dbms_utility.format_error_stack, 1, 200));
commit;
end testABC;
ORACLE存过的基本格式
最新推荐文章于 2023-07-04 09:59:19 发布