Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: how do I print just my messages??
Hi Laura,
This message is feedback. Other feedback messages are
n rows selected/insert/deleted
commit complete
synonym created
etc. etc.
It is possible to issue the command
set feedback off
but this just disables ALL feedback not only 'Pl/sql procedure...' etc and
should be used with caution.
Hth,
Sybrand Bakker, Oracle DBA
Laura González wrote in message <376A3B7E.40CD74B3_at_stl.es>...
>Hi, I hope this is not a question too simple for you, but I am starting
>now with ORACLE and I still have 'simple problems':
>
>I've writen several shell scripts for the daily operations job like:
> sqlplus -s user/password << END
> --
> --
> END
>
>I'd like to print several messages and I am using for this issue:
>
> SET SERVEROUTPUT ON
> --
> --
> DBMS_OUTPUT.PUT_LINE('This is my message');
>
>
>But whe I do that, always appear messages like:
>
> PL/SQL procedure successfully completed.
>
>Is it posible to avoid this message?. Thank you very much.
>
>
>
>
>--
>***************************************************************************
**
>
>Laura González
> Tlfno : 91.348.92.35
>Dept. Sistemas de Información Fax : 91.348.91.13
>Sistemas Técnicos de Loterías e-mail:
>l_gonzalez_at_stl.es
>
>***************************************************************************
**
Received on Fri Jun 18 1999 - 12:44:48 CDT