Home » SQL & PL/SQL » SQL & PL/SQL » UPDATE statement caused error (Oracle 9i)
UPDATE statement caused error [message #330200] Fri, 27 June 2008 22:10 Go to next message
deviji
Messages: 23
Registered: November 2007
Junior Member
Dear All,

I have a problem like the UPDATE statement caused exceptions and stopped it between.

Is there any way to find how many rows got updated and continue from the rest.

So that we can UPDATE the rest of the rows and make use of the updated data meanwhile

Thanks in advance.

Regards,
Viji
Re: UPDATE statement caused error [message #330204 is a reply to message #330200] Fri, 27 June 2008 22:38 Go to previous messageGo to next message
BlackSwan
Messages: 25036
Registered: January 2009
Location: SoCal
Senior Member
http://www.orafaq.com/forum/t/88153/0/
Please read & FOLLOW the Posting Guideline as stated in URL above

>Is there any way to find how many rows got updated
Yes, the number of rows which got updated is ZERO.

[Updated on: Fri, 27 June 2008 22:39] by Moderator

Report message to a moderator

Re: UPDATE statement caused error [message #330206 is a reply to message #330204] Fri, 27 June 2008 22:47 Go to previous messageGo to next message
deviji
Messages: 23
Registered: November 2007
Junior Member
Hi anacedent,

I apologise if there is any mistake.

but i didn't get why you asked me to visit the guidelines.

Thanks for your guidelines.

regards,
viji
Re: UPDATE statement caused error [message #330208 is a reply to message #330200] Fri, 27 June 2008 22:56 Go to previous messageGo to next message
BlackSwan
Messages: 25036
Registered: January 2009
Location: SoCal
Senior Member
Below all are from the Guidelines.
Which did you follow & do?

Post exact Database (4 decimal places, please) and OS version. By doing so, you'll avoid reactions using features you can't use.

Show us what you did

Do not describe your problem
Re: UPDATE statement caused error [message #330216 is a reply to message #330200] Sat, 28 June 2008 00:33 Go to previous message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
In 9i, most of the time you have to do it in PL/SQL.
In newer version you could use error logging clause.

Regards
Michel
Previous Topic: Calculating absent days
Next Topic: Updating table using triggers
Goto Forum:
  


Current Time: Sun Dec 04 12:21:45 CST 2016

Total time taken to generate the page: 0.07651 seconds