Referential Integrity Using View

From: Mahesh, MS, PMP <mahesh_swam_at_yahoo.com>
Date: 18 Jul 2006 07:34:17 -0700
Message-ID: <1153233257.507791.202990@b28g2000cwb.googlegroups.com>

In ORACLE 10g is there a way to use a view as the target of a foreign key definition?

Let me explain the situation. We use the ATG framework (ATG commerce framework) which uses repository files (ORM) to access the data repository. It has an internal structure for accessing products. We have our own product database which we can access by overriding the default XML repository file to point to our tables instead of ATG product tables.

The problem is that when we want to use the commerce framework and use persistent shopping cart there are foreign keys to the ATG product tables and since they are empty it causes foreign key violation.

Specifically table dcspp_item (holds shopping cart item) has a reference to dcs_product (ATG's product table) and is there a way we can create a view that has it instead refer to our own product table? So is there anything we can do short of populating the keys and/or disabling the constraints?

Thanks in advance. Received on Tue Jul 18 2006 - 09:34:17 CDT