473,666 Members | 2,116 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

How to continue processing if an error occur into plsql block

1 New Member
Hi,

This is puru.

Could you please help me to resolve captioned issue :

e.g. if we have one update which going to update more than one row and it is
facing some error to update some rows.

I want to continue the prcesssing and update the rest of rows successfuly.

Thanks
Nov 26 '07 #1
2 2360
amitpatel66
2,367 Recognized Expert Top Contributor
Which version of oracle you are using?
Nov 26 '07 #2
singhh04
4 New Member
Hi Puru,

This can be done using FOR ALL and Save Exception method.

However, could you please come up with the version of oracle you are using.
Nov 26 '07 #3

Sign in to post your reply or Sign up for a free account.

Similar topics

0
3423
by: Corrine | last post by:
I am trying to pass a temporary BLOB that I've created in Java, to a PLSQL function that modifies it, and then to retrieve this modified value back to Java, all using JDBC. I can't figure out how to get the modified BLOB object back to Java after the PLSQL block has finished executing. I do: BLOB bl = BLOB.createTemporary(db,true,BLOB.DURATION_SESSION);
3
423
by: Antipode | last post by:
Hi, I'm writing a simple application that deletes multiple directories. I want to write it so that it will simply continue on through the list of directories if an exception is thrown (the directory is not there). Is there a way to do this? Am I approaching this all wrong?
5
3917
by: Matthew Hood | last post by:
I have a DLL I created to handle all unknown errors using the Application.ThreadException event. I'm asking the user if they want to terminate the program or continue. This is working like I want. The program exits when I tell it to terminate, and when I continue, the program keeps running but the routine that generated the error exited. I want to take this a step further though. Instead of the routine that generated the error...
2
5377
by: Piper707 | last post by:
Hi, I need to know if there is any way of achieving conditional processing for XSD elements. --------------------------------------------------------------- <criteria></criteria> = a complex element <join_condition></join_condition> = a simple element --------------------------------------------------------------- EX:
14
1506
by: Rex | last post by:
Re: Looking for Tips/Writeup on overall approach to Exception Processing Hi All - I am fairly new to C# and am wondering how to best implement (overall) Exception Processing within my (reasonably-sized) C# Windows application. I do have a bunch of somewhat random questions on this and if you can help me with only one or a few, that would still be APPRECIATED. Here are my questions: 1. Is it recommended to put all of the "Main" coding...
1
2354
amitpatel66
by: amitpatel66 | last post by:
Hi, Is PLSQL Anonymous block allowed in CASE WHEN statement when CASE is used in SELECT statement. Check below code which executes but does not return anything: SELECT job, CASE WHEN job = 'TL' THEN DECLARE CURSOR C1 IS SELECT ename FROM emp WHERE job = 'TL'; concat_str VARCHAR2(2000) := NULL;
2
2355
by: SAMEER CHAUDHARI | last post by:
hi friends, i hv my plsql block in that i use goto statement in that i got the error above mesion. my plsql block is create procedure xyz(abc in number)
1
2003
by: Elmo Watson | last post by:
in a Try/Catch block - once an error is thrown, is there any way to set it so that it will continue through the rest of the procedure? (in the catch block, I'm firing off an email with the error message)
36
2642
by: mdh | last post by:
May I ask the group this somewhat non-focused question....having now seen "continue" used in some of the solutions I have worked on. ( Ex 7-4 solution by Tondo and Gimpel comes to mind) Is there a good principle/s for the good usage of "continue"...or...do any of the regular/irregular contributors have a "favorite" way in which it is particularly useful. Thanks as usual.
0
8445
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
8356
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
8871
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
0
8781
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
1
8551
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
1
6198
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
5664
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
1
2771
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
2
2011
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.