DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: PL/SQL code

Threaded View

  1. #2
    Join Date
    Jul 2002
    Location
    Slovenia
    Posts
    42
    MAYBE YOU MUST REMOVE ONE 'E' FROM SECOND INDEX...
    EXECUTE IMMEDIATE 'CREATE BITMAPE INDEX zi2 on z_tst(c2)';

    set serveroutput on
    begin
    begin
    EXECUTE IMMEDIATE 'CREATE BITMAP INDEX zi1 on z_tst(c1)';
    exception when others then
    dbms_output.put_line('blabla1');
    end;
    begin
    EXECUTE IMMEDIATE 'CREATE BITMAPE INDEX zi2 on z_tst(c2)';
    exception when others then
    dbms_output.put_line('blabla2');
    end;
    begin
    EXECUTE IMMEDIATE 'CREATE BITMAP INDEX zi3 on z_tst(c3)';
    exception when others then
    dbms_output.put_line('blabla3');
    end;
    end;
    Last edited by andrejm; 05-14-2003 at 04:18 AM.
    Andrej

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width