存储过程部分:
create or replace package body PKG_AGE is
procedure AGE(c_result out varchar2) as
nsql varchar2(4000);
isExist integer;
begin
--------------------清空表数据--------------
c_result:='执行成功xx';
EXCEPTION
WHEN others THEN
begin
c_result:='错误:'||sqlerrm;
--Rollback;
dbms_output.put_line(sqlerrm);
return;
end;
end AGE;
end PKG_AGE;
代码部分:
OracleParameter[] paramlst = new OracleParameter[]
{
new OracleParameter("c_result", OracleType.VarChar, 4000)
};
paramlst[0].Direction = ParameterDirection.Output;
dt = PublicClass.GetPrcDataSet("PKG_AGE.AGE", paramlst);
logcontent = paramlst[0].Value.ToString();
输出的内容:
记录消息:
logcontent的内容是:'执行成',不是'执行成功xx';