Re: Problem With Foreign Key
Posted by: Richard Ostler
Date: April 11, 2007 02:01AM

Your parent and child key fields use different datatypes. emp_leave.employee_id is defined as varchar(6) while emp_user.employee_no is defined as int(11). They must be the same datatype.

Richard

Options: ReplyQuote


Subject
Written By
Posted
April 11, 2007 12:19AM
Re: Problem With Foreign Key
April 11, 2007 02:01AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.