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

Do a 'set serveroutput on' first (run it from SQL/Plus) to see the output. Otherwise you get nothing.

The reason it doesn't work is you don't have privileges (execute permission) on dbms_output, so connect as SYS, and 'grant execute on dbms_output to yourusername'. Then reconnect and try again.

"Pierre HIRTH" <p.hirth_at_sbm.mc> wrote in message news:9b4jgd$224h$1_at_news6.isdnet.net...
> 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 Tue Apr 17 2001 - 05:04:36 CDT