Re: Updating A View From Oracle

monisha_at_pms913.pms.ford.com writes:

>Hello Oracle Users,
 We are working with a large application written under UNIX/MOTIF
>The application accesses a remote ORACLE Database and presents screens to
>the user which are essentially"views". i.e. the user will need to update fields
>in the screen but the screen is composed of columns from multiple tables.
>Essentially this means updating a view which is not supported in ORACLE6.0.
>Which is the easiest or the best possible way to do it?
>Any Suggestions????

1. the user needs update privilege on each and every table the view is based on;
2. the view needs to contain all primary key columns from the tables it uses;
3. in your commit logic, update the underlying table(s) using the primary keys you get from the view. That's the reason you need the primary key columns.

Hope this helps.

--
 Alvin W. Law ........................................... Oracle Corporation
 Senior Applications Engineer ............... 300 Oracle Parkway, Box 659306
 Oracle Manufacturing ............................. Redwood Shores, CA 94065
 Email: alaw_at_oracle.com ....... Voice: 415.506.3390 ...... Fax: 415.506.7299