Home » SQL & PL/SQL » Client Tools » Remove/Prevent "PL/SQL procedure successfully completed" message (Oracle 10g v10.2.0.4.0)
Remove/Prevent "PL/SQL procedure successfully completed" message [message #472383] Fri, 20 August 2010 05:04 Go to next message
andrewmurphy
Messages: 9
Registered: June 2010
Location: Ireland
Junior Member
With the Test Proc below, I'm getting the output file below. However I do not want the "PL/SQL procedure successfully completed." message in my output file - I don't see/recognise an option to suppress or remove this.

Please advise.

-- Test Proc
--
set linesize 500
set pagesize 50000
set tab off
set wrap off
set serveroutput on
set feedback on

begin
dbms_output.put_line('1 here we go');
end;
/
exit;


output file
1 here we go

PL/SQL procedure successfully completed.
Re: Remove/Prevent "PL/SQL procedure successfully completed" message [message #472384 is a reply to message #472383] Fri, 20 August 2010 05:09 Go to previous messageGo to next message
andrewmurphy
Messages: 9
Registered: June 2010
Location: Ireland
Junior Member
Doh! Resolved by reading http://www.orafaq.com/forum/t/160177/153650/.

Set feedback off
<>
--set feedback on

The joys of searching for a topic and not knowing the right keywords to get a useful answer.
Re: Remove/Prevent "PL/SQL procedure successfully completed" message [message #472505 is a reply to message #472384] Sat, 21 August 2010 03:35 Go to previous message
Frank
Messages: 7877
Registered: March 2000
Senior Member
Thanks for getting back with the correct answer; most people would not have taken the trouble.
Previous Topic: Creating spool file dynamically
Next Topic: Help with accepting input from the user after executing SQL stmts in PL/SQL procedure
Goto Forum:
  


Current Time: Tue Sep 30 19:18:42 CDT 2014

Total time taken to generate the page: 0.10893 seconds