Re: PO7 Foreign Key???

The Poster formerly known as Barbara Moore wrote:

Jonathan Gennick was kind enough to provide me with the SQL*Plus syntax I needed to get the specific job I was working on done. I had to delete the tables and recreate them in SQL and it looks like this is what I’ll continue to do unless I can figure out why Oracle Navigator is behaving like this.

I’d still like to know if anyone else has had a similar problem with PO7. Bottom line is - the GUI Oracle Navigator New Table function just flat won’t let me assign foreign keys unless the parent primary key column(s) are also defined as UNIQUE. This occurs in both the CREATE TABLE MANUALLY and USE TABLE WIZARD paths.

When I type the foreign key owner.parent_table(primary_key_column), or select it during a TABLE WIZARD session, I get the error message:

"ORA-02270: no matching unique or primary key for this column-list"

This occurs whether I have one or more than one foreign key column.

Interestingly enough, when the tables are created in SQL, I still don’t see the foreign keys in the child table properties when I look at them from Oracle Navigator, but Developer Forms 4.5 lets me establish the Master/Detail relationships between the tables, so I know they’re there.

I’m beginning to wonder if this is some sort of installation glitch.

John Thompson Received on Fri Jan 02 1998 - 00:00:00 CST