PL/SQL Oracle Error Handling -

-

I created a trigger that gives 10 existing orders to only one user, so now when the customer moves the order number 11 , Oracle database throws an error back. Well 3 Errors

ORA-20000: You currently have 10 or more order processing.

ORA-04088: error during execution of trigger 'C3283535.TRG_ORDER_LIMIT'

ORA-06512: "C3283535.TRG_ORDER_LIMIT"

The top error is one I have used:

raise_application_error (-20000), 'you currently have 10 or more order processing.');

I was just thinking after searching and was trying to change error messages for other two errors or show them in many ways for the user all together?

Here is the code I used 

  Before entering the placed_order for each row, declare the v_count number to trigger or change trg_order_limit; Start - get calculation count (order_ID) of the current order count placed in v_count / command where fk1_customer_id =: new.fk1_customer_id; - Increase exception if there are too many if v_count & gt; = 10 exceptions while other raise_application_error (-20000, 'you currently have 10 or more order processing.'); end if; End;   
 Many thanks Richard   
 
 
 Exception spread-to-external Block, which is the opposite of the variable scope, which comes out from the inner block of the interior. For more context about this, read McLoughlin's "Programming with PL / SQL", Chapter 5.  
 An exception stack is what you are doing here - the exceptions raised from the inner block for outermost blocks. > 
 When you raise an exception with a trigger, your  raise_application_error  statement returns a error.  
 Then it is promoted for the trigger block which says  ORA-06512: "C3283535.TRG_ORDER_LIMIT", line 12 . This is because the trigger prevents an exception raised as an error and continues to continue.  
 The error is then propagated to the session which is 'code' ORA-04088: error 'C3283535 TRG_ORDER_LIMIT'  during execution of the trigger. This error tells us about, as part of the program, the error was raised.  
 If you are using front-end programs like Java Server Pages or PHP, then you will catch the error raised - 20000 First, you can also display it to your end user. Edit   > Can change in statement only.  
 If you want to handle  ORA-06512 , then you can use Uday Shankar's answer to take care of this error and help show a suitable error message. .  
 But, you can still get the last  ORA-04088 . If I was in your place, I would not be worried, after getting the  ORA-20000 , I extend an application error on the front side while hiding all the other details from the user.  
 In fact, this is  is  the nature of the exception stack of Oracle. All the errors from inner side to the outermost block have been raised. This is useful sometimes for us to identify the exact source of error.

Comments

Post a Comment

Popular posts from this blog

excel vba - How to delete Solver(SOLVER.XLAM) code -

-
After opening several examples of macro / code written, I suddenly get stuck with a code that seems safe. Solver (SOLVER.XLAM) is doing this notation and I would like to remove it from my system. I do not think this is a relativant code. Can anyone tell me what should I do? I have already installed something to remove the password but Solver is still asking for password and I can not get rid of it! itemprop = "text"> Solver Excel is add-in If you want to delete it, then Excel Application & gt; Options & gt; Add-ins & gt; Search for 'Go to' button and gt; Uncheck the solver on the list like press something (I can not give you the exact path because I have the Polish version of Excel). Trying to open Solver's VBA code is not good because it There is allegedly copyright. Besides, I do not think Solver creates any disadvantages while working with Excel or VBA.
Read more

github - Teamcity & Git - PR merge builds - anyway to get HEAD commit hash? -

-
I have a team city build project with Gitbab VCS route, I have been triggered for both / head on PR and / Merge the referee. The annoying thing is that you can not do anything useful with the merged hash - it is not present in Gitobb. I want to exclude newsgate packages with head in gutub comet situations in the version number along with Hewash (Newsaging 7) for the music build, but against head hash. However, I can not see a way to get the head hashes while constructing that merge. I just want to head because it's useless - we only care about merge. (PR - Pull Request) This command works reliably while running One on / merge is git log --no-merge -1 ---- = '% h'
Read more

ios - Replace text in UITextView run slowly -

-
I have a UITextView and I change a word like the code at the end of UITextView.text: - (void) Replace TexttechWitWord: (NSString *) word {NSString * currentTextViewText = self.textView.text; CurrentTextViewText = [currentTextViewText stringByReplacingCharactersInRange: NSMakeRange ([self.textView.text length] - [word length], [word length]) withString: word; Self.textView.text = currentTextViewText; } Replacement work is fine, but it runs very slowly and very slowly when the textView now lengthens Is there any better way? I try the replacement range: with text for a week but still stuck. Not to know how to use it to replace it in your case. Please guide! Thanks in advance! This is an important job. As you are using an irreversible string and you are creating a very long string and before Assigned to NSString created from. NSString will be used instead of NSMutableString . - (UITableViewCell *) TableView: (UITableView *) Table View CellForOutPath: (NSIndex...
Read more