How do I Suppress "PL/SQL procedure successfully completed" message in sqlplus?

oracle plsql sqlplus
JJMoho picture JJMoho · Oct 30, 2008 · Viewed 32.6k times · Source

Is there a way that you can have SERVEROUTPUT set to ON in sqlplus but somehow repress the message "PL/SQL procedure successfully completed" that is automatically generated upon completed execution of a plsql procedure?

Answer

Tony Andrews picture Tony Andrews · Oct 30, 2008

Use the command:

SET FEEDBACK OFF

before running the procedure. And afterwards you can turn it back on again:

SET FEEDBACK ON

Related questions

PL/SQL ORA-01422: exact fetch returns more than requested number of rows

I get keep getting this error I can't figure out what is wrong. DECLARE * ERROR at line 1: ORA-01422: exact fetch returns more than requested number of rows ORA-06512: at line 11 Here is my code. DECLARE rec_ENAME EMPLOYEE.ENAME%TYPE; …

Read More
ORA-12154: TNS:could not resolve the connect identifier specified (PLSQL Developer)

I need to use PLSQL Developer to access oracle databases. I get the following error when I try to connect to my database. ORA-12154: TNS:could not resolve the connect identifier specified. I am able to use SQLPLUS from the …

Read More
How do you execute SQL from within a bash script?

I have some SQL scripts that I'm trying to automate. In the past I have used SQL*Plus, and called the sqlplus binary manually, from a bash script. However, I'm trying to figure out if there's a way to connect …

Read More