Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Count of sucessfully processed rows

Count of sucessfully processed rows

From: Shankaran <asshankaran_at_hotmail.com>
Date: 24 Jan 2003 05:16:26 -0800
Message-ID: <795fe36c.0301240516.68a6e453@posting.google.com>


This is my problem.
I am updating the empid column of the table emp as
update table emp
set empid = new_empid;
somewhere it comes up with the primary key constraint error. Can I narrow down on the problematic row JUST by looking at the error variables populated by Oracle server.
(I dont want to write a query to find the problematic row. Is there any way out without writing a query to findout the problematic row)

Kindly help me out... Received on Fri Jan 24 2003 - 07:16:26 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US