Home » SQL & PL/SQL » SQL & PL/SQL » Regarding buffer overflow error
Regarding buffer overflow error [message #223976] Mon, 12 March 2007 08:47 Go to next message
rolex.mp
Messages: 161
Registered: February 2007
Senior Member
I am updating a huge table and when the updation takes place a trigger fires and the statement in the trigger body gets printed.

Since the table is huge I did set the size of serveroutput to 1000000 , but still i get the buffer overflow error .

The message has to be printed I cannot set the serveroutput off and I also want the entire update to complete without any errors.

Is there some means to solve this problem ?
Re: Regarding buffer overflow error [message #223977 is a reply to message #223976] Mon, 12 March 2007 08:51 Go to previous messageGo to next message
joy_division
Messages: 4644
Registered: February 2005
Location: East Coast USA
Senior Member
Having output in a trigger is pointless. What if some other process other than your SQL*Plus session causes the trigger to fire? Who would you expect to see this output?
Triggers should not have output. It is a bad idea. It could be used for debugging purposes only.

[Updated on: Mon, 12 March 2007 08:51]

Report message to a moderator

Re: Regarding buffer overflow error [message #223984 is a reply to message #223976] Mon, 12 March 2007 09:32 Go to previous messageGo to next message
rolex.mp
Messages: 161
Registered: February 2007
Senior Member
No this is just a test case , so the user who runs it would like to check the order of firing of triggers so thats why we need to display some output to the user specifying some details.

Is there anyway through which I can solve the issue?
Re: Regarding buffer overflow error [message #223992 is a reply to message #223984] Mon, 12 March 2007 10:23 Go to previous message
Frank
Messages: 7880
Registered: March 2000
Senior Member
If it is just a testcase to see the order of the triggers, there is no need to update so many rows.
By the way, the order in which same-level-same-triggering event-same-table triggers fire is random. If it has a specific order today, it might change tomorrow..
Previous Topic: To compute total amount in one SQL statement
Next Topic: cursors
Goto Forum:
  


Current Time: Sat Dec 10 03:19:09 CST 2016

Total time taken to generate the page: 0.08981 seconds