Re: DBD::Oracle foreign key problem

It seems that the machine volcano does not exist in some other table, or at least that's what the failing constraint LRRS.RESERVATION_MACHINE_FK1 seems to suggest to me.

If you can tell us the definition of that constraint, maybe we can see more. Also, showing the actual INSERT statements that work might also help.

Comment on Re: DBD::Oracle foreign key problem Select or Download Code

Replies are listed 'Best First'.
Re^2: DBD::Oracle foreign key problem by digdoug (Initiate) on Feb 03, 2010 at 18:11 UTC
Yep, the host name needed to exist... well somewhere. After 'communicating' with our dba, I'm still left with unanswered questions but, it's not like I got actual requirements/info/love for this project anyway! sigh With a little research i'll figure out how to get Oracle to tell me about these mysterious constraints. Maybe table_info()? Anyway, thanks, this place is awesome as usual.	[reply]