CAN'T UPDATE MULTIPLE TABLES IN VIEW

Hi!

        Were using a FeebleBuilder(a.k.a. PowerBuilder) front-end to an Oracle Workgroup server 7.3.2.0.1 running under NT, and we've encountered a problem. FeebleBuilder will only generate SQL for updates for one table in a query, and so if I want to use multiple tables in an updatable form, I need to either use two or more datawindow controls (which in most parent-child situations is OK), or base the datawindow on a back-end view.

        The problem is that Oracle will not allow me to update more than one of the base tables in the view at a time! I love Oracle; it's the only product in the marketplace that I wholeheartedly endorse, but it seems here that it cannot handle an operation that even MS Access can do.

        My specific situation is that I have two tables joined 1-to-1 (via a foreign key constraint and a unique column constraint on that foreign key), and that the view explicitly selects all columns of each table. There's no ambiguity here; the DBMS should be able to tell where each piece of data needs to go.

        Can anyone out there suggest a possible workaround or other black magic that'll make this work?

        Thanks in advance,

	Jim Mitchell
	jmitch_at_clark.net