Hi,
Thanks all for help !!
Sue



oracledba-ezmlmsh
ield-x65628367.x1
[Email Address Removed] To
.[Email Address Removed] [Email address protected]
Sent by:
oracledba-return- cc
131796-SHEUEHUA.L
EUFUH=marsh.[Email Address Removed]
azydba.com Subject
RE: commit point

08/30/2006 01:09
PM










We can inside the stored procedure also.
We generate set the commit either after the execution of the sp or the
last point inside the sp to maintain the concurrency of the transaction.

Suraj





-----Original Message-----
From: Sheuehua
[mailto:oracledba-ezmlmshield-x31607677.[Email address protected]
Sent: Wednesday, August 30, 2006 8:10 PM
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-return-131796-SHEUEHUA.LEUFUH=marsh.[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.
**********************************************************************

Oracle LazyDBA home page