Home » SQL & PL/SQL » Client Tools » Inhibit displaying messages in the "Script Output" window (Oracle SQL Developer 1.5.5)
Inhibit displaying messages in the "Script Output" window [message #494833] Thu, 17 February 2011 04:38 Go to next message
cvp57
Messages: 3
Registered: February 2011
Junior Member
Hi, I apologize from the beginning if I posted my question in the wrong section.
I began studying Oracle and SQL Developer and I have the following question:
If I run a large number of INSERT commands into a table using a SQL Worksheet from the SQL Developer, the fact that in the "Script Output" window a "1 rows inserted" message appears for each created record greatly slows the execution.
How can I inhibit displaying this message in the "Script Output" window during the execution of my INSERT commands?

Re: Inhibit displaying messages in the "Script Output" window [message #494836 is a reply to message #494833] Thu, 17 February 2011 04:48 Go to previous messageGo to next message
cookiemonster
Messages: 12992
Registered: September 2008
Location: Rainy Manchester
Senior Member
You could wrap the whole thing in a BEGIN/END and treat it as a single PL/SQL block.
Re: Inhibit displaying messages in the "Script Output" window [message #494842 is a reply to message #494836] Thu, 17 February 2011 04:58 Go to previous messageGo to next message
Michel Cadot
Messages: 65317
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Does "set feedback off" work in SQL Worksheet? It is worth to try it.

Regards
Michel
icon9.gif  Re: Inhibit displaying messages in the "Script Output" window [message #494849 is a reply to message #494842] Thu, 17 February 2011 05:11 Go to previous messageGo to next message
cvp57
Messages: 3
Registered: February 2011
Junior Member
No, unfortunately "set feedback off" does not solve the problem ... messages still appear.
Re: Inhibit displaying messages in the "Script Output" window [message #494851 is a reply to message #494849] Thu, 17 February 2011 05:23 Go to previous messageGo to next message
Roachcoach
Messages: 1508
Registered: May 2010
Location: UK
Senior Member
Calling the inserts as a script seemed to work for me, though I'm on a higher version.

Edit: Although that may be because set feedback off worked for me.

2.1.1.64

[Updated on: Thu, 17 February 2011 05:25]

Report message to a moderator

Re: Inhibit displaying messages in the "Script Output" window [message #494858 is a reply to message #494851] Thu, 17 February 2011 06:08 Go to previous message
cvp57
Messages: 3
Registered: February 2011
Junior Member
You were absolutely right! I updated to the latest version and now everything is OK.

Laughing 10x. Laughing
Previous Topic: Unable to delete a row
Next Topic: PL*SQL - Which users are ACTIVE ?
Goto Forum:
  


Current Time: Sun Jan 21 03:48:41 CST 2018

Total time taken to generate the page: 0.09167 seconds