sqlplus smis/smissmis
set serveroutput on
col column_name format a44;
set linesize 1000;
declare lv_i number;
begin
--包名.称存储过程名称(参数......);
GL_Load.Load_2DB('2006-12-31', 'ERPF_CURR_CNTRA', lv_i);
end;
/
vc_error_text := SQLERRM;
vl_error_code := SQLCODE;
avc_errtext := vc_error_text;
an_ret := -1;
Longshine_Insert_Oper_Log(vc_object_name,vc_error_text);
Commit;
DBMS_OUTPUT.PUT_lINE(vc_error_text);[@more@]
set serveroutput on
col column_name format a44;
set linesize 1000;
declare lv_i number;
begin
--包名.称存储过程名称(参数......);
GL_Load.Load_2DB('2006-12-31', 'ERPF_CURR_CNTRA', lv_i);
end;
/
vc_error_text := SQLERRM;
vl_error_code := SQLCODE;
avc_errtext := vc_error_text;
an_ret := -1;
Longshine_Insert_Oper_Log(vc_object_name,vc_error_text);
Commit;
DBMS_OUTPUT.PUT_lINE(vc_error_text);[@more@]
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/154324/viewspace-1009256/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/154324/viewspace-1009256/