Hello,

Suppose that you have the following PL/SQL code :

begin
EXECUTE IMMEDIATE 'CREATE BITMAP INDEX zi1 on z_tst(c1)';
EXECUTE IMMEDIATE 'CREATE BITMAPE INDEX zi2 on z_tst(c2)';
EXECUTE IMMEDIATE 'CREATE BITMAP INDEX zi3 on z_tst(c3)';
end;

After executing this procedure, only the first index will be created (a systax problem for zi2 index). The third index will not ba created.

How can I do create the thrid index even if I have a problem with creating the second (so, let Oracle not exiting the program ...).

Think in advance