+ -
当前位置:首页 → 问答吧 → 【求救】oracle 存储过程 报错:check compiler log

【求救】oracle 存储过程 报错:check compiler log

时间:2011-11-01

来源:互联网

SQL code

create or replace
procedure "pro_insert_InchInfo" 
(inch_info_filename in varchar2,inch_file_byte in blob,c_name in varchar2,c_idcard in varchar2,regionCode in varchar2 )
as
begin  
insert into inch_info(inch_id,inch_file_name,inch_file_byte,regional_code,ps_process_status,ps_process_date) values(inch_info_seq.nextval, inch_info_filename,inch_file_byte,regional_code,'U',sysdate);
insert into card_info(card_id,user_name,USER_IDENTIFICATION,regional_code,inch_id)values(card_info_seq.nextval,c_name,c_idcard,regional_code,inch_info_seq.currval);
commit;
exception
when others then 
rollback;
end pro_insert_InchInfo;



结果编译报错:大家帮我看看吧。
刚刚开始使用oracle

作者: liuxiulian   发布时间: 2011-11-01

它让你“check compiler log”,你就看看log 呗。
log里肯定把错误信息都显示出来了。

作者: yixilan   发布时间: 2011-11-02