ORA-08177: error

[fernando.olmos at hpa.com.au]

Yeah, we figured that but it's too risky without a good roll back.
 
I found that if I placed an ADD UPDATE, and not just an ADD after the
OUTPUT clause, it worked! It looks like PH is opening the connection to
the database differently when you say ADD UPDATE as opposed to just ADD.
Mind you this only works of course, if we're creating a subfile from the
table we're going to add back into again later on. If the logic
specifically only wants an ADD, even when there are possibilities of an
UPDATE occurring because of similar primary keys, then we're in trouble.
 
I think the best way to resolve this is to figure out how Oracle is been
accessed when it's an ADD vs an ADD UPDATE.
 
Cheers
 
-----Original Message-----
From: VGoparaju at tradepointsystems.com
[mailto:VGoparaju at tradepointsystems.com] 
Sent: Thursday, October 13, 2005 1:53 PM
To: Fernando Olmos
Cc: powerh-l at lists.sowder.com
Subject: RE: ORA-08177: error


One of the solutions is to use COMMIT AT <n transactions> could be
COMMIT at 1000 transactions. 
 
Sagar Goparaju
TradePoint
 
-----Original Message-----
From: powerh-l-bounces+vgoparaju=tradepointsystems.com at lists.sowder.com
[mailto:powerh-l-bounces+vgoparaju=tradepointsystems.com at lists.sowder.co
m]On Behalf Of fernando.olmos at hpa.com.au
Sent: Wednesday, October 12, 2005 10:36 PM
To: powerh-l at lists.sowder.com
Subject: ORA-08177: error
 
Has anyone experienced this error when trying to ADD records from a
subfile into an Oracle table? 
ORA-08177: can't serialize access for this transaction 
We get this sometimes, and other times we don't. It's weird. 
Thanks 
Fernando Olmos 
M.I.S. 
HPA
Direct:  03 9217 5411
Mobile: 0410 382 857
Fax:     03 9217 5716 
 <file:///H:/Appdata/Microsoft/Signatures/www.hpa.com.au> www.hpa.com.au

 
**********************************************************************
IMPORTANT
The contents of this e-mail and its attachments are confidential and
intended
solely for the use of the individual or entity to whom they are
addressed.  If
you received this e-mail in error, please notify the HPA Postmaster,
postmaster at hpa.com.au,
then delete  the e-mail.
This footnote also confirms that this e-mail message has been swept for
the
presence of computer viruses by Ironport. Before opening or using any
attachments, check them for viruses and defects.
Our liability is limited to resupplying any affected attachments.
HPA collects personal information to provide and market our services.
For more
information about use, disclosure and access see our Privacy Policy at
www.hpa.com.au
**********************************************************************
STATEMENT OF CONFIDENTIALITY:
The information contained in this electronic message is intended for the
exclusive use of the addressee(s) and may contain confidential
information.  If you are not the intended recipient of this email, be
advised you have received this message in error and that any use,
dissemination, forwarding, printing, or copying is strictly prohibited.
Please notify TradePoint Systems LLC immediately at (603) 889-3200 and
destroy all copies of this message and any attachments.
**********************************************************************
IMPORTANT
The contents of this e-mail and its attachments are confidential and intended
solely for the use of the individual or entity to whom they are addressed.  If
you received this e-mail in error, please notify the HPA Postmaster, postmaster at hpa.com.au,
then delete  the e-mail.
This footnote also confirms that this e-mail message has been swept for the
presence of computer viruses by Ironport. Before opening or using any
attachments, check them for viruses and defects.
Our liability is limited to resupplying any affected attachments.
HPA collects personal information to provide and market our services. For more
information about use, disclosure and access see our Privacy Policy at
www.hpa.com.au
**********************************************************************
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.sowder.com/pipermail/powerh-l/attachments/20051013/c6a17c00/attachment.htm