Home » SQL & PL/SQL » SQL & PL/SQL » procedure problem
procedure problem [message #7998] Mon, 21 July 2003 13:28 Go to next message
DR
Messages: 12
Registered: July 2003
Junior Member
I have a procedure that contains the following code:

update tableone a
set a.parmtype = (select distinct b.parmtype
from tabletwo b
where b.parm = a.parm);
commit;

The procedure works fine for smaller tables, but causes rollback segment errors for larger ones. I know that I need to commit more frequently, but need some assistance with the code.

Thank you...DR

Report message to a moderator

Re: procedure problem [message #7999 is a reply to message #7998] Mon, 21 July 2003 13:53 Go to previous message
Todd Barry
Messages: 4819
Registered: August 2001
Senior Member
Actually, you do not want to commit more frequently - you need to size your RBS properly (larger).

Report message to a moderator

Previous Topic: want to enable constraint (pk-fk)
Next Topic: Function...
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Apr 26 03:04:53 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.