Hi All,

I want to catch the error in a variable. Can you please helpme in writing
this proc.

create or replace procedure test45
is
v_sql VARCHAR2(500);
declare @errorflag int
begin
begin tran
v_sql := 'select no from ran';
EXECUTE IMMEDIATE v_sql;
if @errorflag<>0 rollback tran
else commit tran
end

regards
Ranjit S.

Oracle LazyDBA home page