게시일: Mar 20, 2014 8:42:4 AM
1. Procedure 작성
procedure test (Param1 in varchar2
,Param2 in varchar2
,InOutParam in out varchar2
)
as
ErrYn varchar2(1000) := null;
ErrMsg varchar2(1000) := null;
begin
각종 로직;
exception
when others then
ErrYn:= 'Y';
ErrMsg := dbms_utility.format_error_backtrace();
return;
end;
2. Procedure 호출
declare
sErrYn varchar2(1) := null;
sErrMsg varchar2(1000) := null;
begin
test('1', '2', sErrYn, sErrMsg);
if sErrMsg = 'Y' then
dbms_output.put_put_line(sErrMsg);
end if;
end;
결과 -> ORA-XXXXX: at "로그인계정.TEST", line 1231