This is a discussion on Where to Trap error...? within the Oracle Database forums, part of the Database category; Table Name : Jobs Jobid Minsal Maxsal J1 1000 2000 J2 2001 3000 J3 3001 4000 I have to update the ...
|
|||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
|
|||
|
Where to Trap error...?
Table Name : Jobs
Jobid Minsal Maxsal J1 1000 2000 J2 2001 3000 J3 3001 4000 I have to update the column Minsal and maxsal . there is a condition Maximum salary should be greater than minimumsalary. if user break this rule obiviously it will show error. we have two set of codeing is here . one is in backend and second is in front end. in front end its very easy trap the two field(Minsal & maxsal) whether its less than minsal . it will show error. but in the case of backend we write it as below : Exception when sal_error then Raise_application_error(-20001,'Data error...Max salary should be greater than min salary...'); here there are 2 questions is that why we trap this error in back end ? and anyway if you write it in backend how we will pass this error to frond end..? As I am a oracle beginer ... expect a good replay |
| Sponsored Links |
![]() |
| Thread Tools | |
|
|
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| web.config gives error if i store string that contin "&" character in appSettings | mahehs_k_anjani | Microsoft .NET | 2 | 09-06-2006 05:21 AM |
| Comp.Sys.Acorn.FAQ part 2 of 4 | Paul Vigay | Tech FAQ | 0 | 05-31-2004 08:00 PM |
| Apple II Csa2 FAQs: Error List, Part 8/25 | rubywand@swbell.net | Tech FAQ | 0 | 05-04-2004 09:01 AM |
| Comp.Sys.Acorn.FAQ part 2 of 4 | Paul Vigay | Tech FAQ | 0 | 04-30-2004 08:00 PM |
| Kerberos FAQ, v2.0 (last modified 8/18/2000) | Ken Hornstein | Tech FAQ | 0 | 04-17-2004 07:28 AM |