Re: Create index only if index not exists in PL/SQL procedure

> In my procedure I do:
>
> 1, Drop index X
> 2, Create table Y as select...
> 3, Create index X for table Y
>

declare
 succ boolean;
begin
 succ := TRUE;
 begin
  exec proc 1;
 exception when others then succ := FALSE;  end;

  if succ then
   begin
    exec proc 2;
   exception when others then succ := FALSE;   end;
 end if;

  if succ then
   begin
    exec proc 3;
   exception when others then succ := FALSE;   end;
 end if;

.
.
.

end;

--
TomekB
www.softman.pl