Here's some pseudo code that might help.

v_counter:=v_counter+1
if mod(v_counter,v_commit_point) = 0 then
commit;
end if;

commit; -- don't forget the last ones


-Ning Wong


-----Original Message-----
From: Sheuehua
[mailto:oracledba-ezmlmshield-x14711566.[Email address protected]
Sent: Wednesday, August 30, 2006 10:07 AM
To: LazyDBA Discussion
Subject: RE: commit point


Yes. inside of stored procedure.



oracledba-ezmlmshield-x38203494.[Email address protected]
08/30/2006 12:09 PM


To
[Email address protected]

cc


Subject
RE: commit point







inside.

-----Original Message-----
From: Sheuehua
[mailto:oracledba-ezmlmshield-x31607677.[Email address protected]
Sent: 30 August 2006 15:40
To: LazyDBA Discussion
Subject: commit point





Hi all,
One of our developer executing a stored procedure but
running out of DB's RBS; can they set commit point into stored procedure
itself or they need to set it out side of stored procedure.
Thanks for any help!!

Sue


**********************************************************************
This e-mail transmission and any attachments that accompany it may
contain information that is privileged, confidential or otherwise
exempt from disclosure under applicable law and is intended solely for
the use of the individual(s) to whom it was intended to be addressed. If
you have received this e-mail by mistake, or you are not the intended
recipient, any disclosure, dissemination, distribution, copying or
other use or retention of this communication or its substance is
prohibited. If you have received this communication in error, please
immediately reply to the author via e-mail that you received this
message by mistake and also permanently delete the original and all
copies of this e-mail and any attachments from your computer. Thank you.

**********************************************************************


---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY To post a
dba job: http://jobs.lazydba.com To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html




---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html




To: [Email address protected]
cc: (bcc: Sheuehua Leufuh/NYC-NY/US/Marsh/MMC)
From: oracledba-ezmlmshield-x38203494.[Email address protected]




**********************************************************************
This e-mail transmission and any attachments that accompany it may contain information that is privileged, confidential or otherwise exempt from disclosure under applicable law and is intended solely for the use of the individual(s) to whom it was intended to be addressed. If you have received this e-mail by mistake, or you are not the intended recipient, any disclosure, dissemination, distribution, copying or other use or retention of this communication or its substance is prohibited. If you have received this communication in error, please immediately reply to the author via e-mail that you received this message by mistake and also permanently delete the original and all copies of this e-mail and any attachments from your computer. Thank you.
**********************************************************************


---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html



Oracle LazyDBA home page