dbms_utility.format_error_stack
babaraviJul 14 2007 — edited Jul 14 2007iam getting error when i use the dbms_utility package..
could please any one of you suggest me to solve this kind of problem.
declare
lv_st agr_mstr.agr_status%type;
lv_error varchar(200);
begin
select agr_status into lv_st from agr_mstr where agr_status='l';
exception
when others then
lv_error:=substr(dbms_utility.format_error_stack,1,100);
dbms_output.put_line(lv_error);
end;
SQL> /
declare
*
ERROR at line 1:
ORA-04063: package body "VHPLUSERS.DBMS_UTILITY" has errors
ORA-06508: PL/SQL: could not find program unit being called
ORA-06512: at line 7
ORA-01403: no data found