OraFAQ Forum: Client Tools » Inhibit displaying messages in the "Script Output" window

Home » Other » Client Tools » Inhibit displaying messages in the "Script Output" window (Oracle SQL Developer 1.5.5)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Inhibit displaying messages in the "Script Output" window [message #494833]

Thu, 17 February 2011 04:38

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?

Report message to a moderator

Re: Inhibit displaying messages in the "Script Output" window [message #494836 is a reply to message #494833]

Thu, 17 February 2011 04:48

cookiemonster
Messages: 13966
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.

Report message to a moderator

Re: Inhibit displaying messages in the "Script Output" window [message #494842 is a reply to message #494836]

Thu, 17 February 2011 04:58

Michel Cadot
Messages: 68749
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Does "set feedback off" work in SQL Worksheet? It is worth to try it.

Regards
Michel

Report message to a moderator

Re: Inhibit displaying messages in the "Script Output" window [message #494849 is a reply to message #494842]

Thu, 17 February 2011 05:11

cvp57
Messages: 3
Registered: February 2011

Junior Member

No, unfortunately "set feedback off" does not solve the problem ... messages still appear.

Report message to a moderator

Re: Inhibit displaying messages in the "Script Output" window [message #494851 is a reply to message #494849]

Thu, 17 February 2011 05:23

Roachcoach
Messages: 1576
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

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.

Report message to a moderator

Previous Topic:	Unable to delete a row
Next Topic:	PL*SQL - Which users are ACTIVE ?

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Mar 12 03:20:25 CDT 2025