' rows merged.'); 18 END; 19 / An important caveat to note is that Oracle will generate an "ORA-30926: unable to get a stable set of rows in the source tables" error if there is either a many-to-one or many-to-many relationship between the source and target tables.
This is not as serious as it sounds because you would normally have to MERGE a one-to-one or one-to-zero relationship as your join condition would be protected by the target's primary key.
What I am demonstrating in this short article is my attempt at decomposing SQL%ROWCOUNT into its component DML counts.This tutorial covers using the Oracle Business Intelligence (BI) Administration Tool to build, modify, enhance, and manage an Oracle BI repository. There will be some differences if you are testing with 22.214.171.124, such as in Create Keys and Joins, Check Consistency, and Set Up Query Logging.There is a new tutorial based on OBI EE 126.96.36.199, please check here. This tutorial shows you how to build an Oracle BI metadata repository using the Oracle BI Administration Tool.You can access the BISAMPLE schema and installation instructions here.If you are interested in downloading and installing the latest version of the entire Sample Application, you can access it here on the Oracle Technical Network (OTN).The data sources can be of the same or different varieties.You can import schemas or portions of schemas from existing data sources.No doubt some of you will consider it a cost too much, but I would argue that in many cases, the extra cost of keeping a package variable updated will be marginal when set against a large, database-intensive MERGE statement.I will be happily using it in my ETL processing, until Oracle includes its own of course!Finally, there is a small procedure to reset the counters.The following is an example of how we might "piggy-back" the earlier MERGE statement to decompose the SQL%ROWCOUNT.