Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: ORA-30926 unable to get a stable set of rows in the source tables
I got the same error with an PL/SQL package generated by Warehouse Builder. In my case, the source table in the merge statement had multiple rows for a single row (update) or no row (insert) in the target table.
Although a SELECT DISTINCT on the source table would have solved the problem, I couldn't get OWB to generate the DISTINCT clause. I found a work-around by adding an aggregate object to generate a GROUP BY clause with no aggregates.
Since the source table is small, I can live with the drop in performance.
(Oracle 9.2 / OWB 9.0.3)
-- Posted via http://dbforums.comReceived on Thu May 08 2003 - 05:11:58 CDT