Exforsys

Online Training

Where to Trap error...?

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 ...


Go Back   Exforsys > Database > Oracle Database

Register FAQ Members List Calendar Search Today's Posts Mark Forums Read
  #1 (permalink)  
Old 03-13-2008, 09:15 AM
Junior Member
 
Join Date: Aug 2005
Posts: 11
jyaseena is on a distinguished road
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
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads

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 06:21 AM
Comp.Sys.Acorn.FAQ part 2 of 4 Paul Vigay Tech FAQ 0 05-31-2004 09:00 PM
Apple II Csa2 FAQs: Error List, Part 8/25 rubywand@swbell.net Tech FAQ 0 05-04-2004 10:01 AM
Comp.Sys.Acorn.FAQ part 2 of 4 Paul Vigay Tech FAQ 0 04-30-2004 09:00 PM
Kerberos FAQ, v2.0 (last modified 8/18/2000) Ken Hornstein Tech FAQ 0 04-17-2004 08:28 AM


All times are GMT -4. The time now is 01:45 AM.


Powered by vBulletin® Version 3.7.3
Copyright ©2000 - 2009, Jelsoft Enterprises Ltd.
Search Engine Friendly URLs by vBSEO 3.1.0
Copyright 2004 - 2007 Exforsys Inc. All rights reserved.