Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: ORA-30926 unable to get a stable set of rows in the source tables

Re: ORA-30926 unable to get a stable set of rows in the source tables

From: dvanbegin <member29327_at_dbforums.com>
Date: Thu, 08 May 2003 10:11:58 +0000
Message-ID: <2854187.1052388718@dbforums.com>

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.com
Received on Thu May 08 2003 - 05:11:58 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US