Re: rebuild or not rebuild index file, when ?, how?

Please, could 'you tel me where the Output are printed when using the dbms_output.put_line('....') function ? And why i 'ahe the message insufiscient privilege' on line 6 when i execute this proc :

CREATE OR REPLACE PROCEDURE BO.CREER_F0902 AS

   i number;
   BEGIN
      i:=i+1;
execute immediate 'Create table bo.f0902 as select * from bo.v$f0902'; execute immediate 'drop table bo.f0902';

 EXCEPTION
 When NO_DATA_FOUND THEN
  dbms_output.put_line('toto');
END;
/

Thank's Received on Thu Apr 12 2001 - 11:00:45 CDT