FRESHERSHOME![]() |
This is a discussion on problem with foreign key in oracle 9i? within the Oracle forums, part of the Data Base Related category; i have two tables emp_master,emp_hw emp_master.empno is primary key and emp_hw.empno is foreing key from emp_master using jsp i inserted ...
| |||||||
| Notices |
| Oracle Oracle related discussion, Oracle configuration, Oracle sql query help, etc |
![]() |
| | Thread Tools | Display Modes |
|
#1
| |||
| |||
| i have two tables emp_master,emp_hw emp_master.empno is primary key and emp_hw.empno is foreing key from emp_master using jsp i inserted a value to emp_hw.empno ( insert into emp_hw values (' ') a null value for which corresponding parent key in the table emp_master NOT THERE. so i should get the error thet PARENT KEY NOT FOUND, but the non parent key value is inserted into emp_hw.empno so this is violating the foreign key constraint. if i am inserting same quary in sql this query is showing the error , only by using jsp is prob what can i do i should get that ereor and non-parent key should not be inserted is this prob b coz of jsp ?
__________________ Powered by Yahoo! |
![]() |
| Thread Tools | |
| Display Modes | |
|
|
Sitemap
Jobs by Location: Advertising and Marketing Jobs - IT Software Jobs - Walk-in Jobs - BPO Jobs - Government Jobs - Sales / BD Jobs - Tele Communication Jobs App Programming - Network Admin
Jobs By Location: Jobs in Bangalore - Jobs In India - Jobs in Delhi - Jobs in Hyderabad - Jobs in Kochi - Jobs in Mumbai - Jobs in Trivandrum - Jobs in pune - Jobs in Jonida - Jobs in Chennai - Jobs in Coimbator
Jobs Type: Full Time Jobs - Part Time Jobs
Latest Jobs - Accounting Jobs - Engineering Jobs - IT Jobs - Walkins - How to Face Interview - HR Round Tips - Career Info - Guide For Freshers - Apply for Jobs - Future Studies - Jobs Forums - Freshers IT Software Salary Details