October 13, 2008 06:38am pdt

My Account

Top 15 Experts

Overall Top Experts

1sdstuber 602,061
2angelIII 381,455
3sujith80 307,642
4jinesh_ka... 177,836
5nav_kum_v 148,281
6schwertner 135,358
7DrSQL 95,258
8jwahl 86,163
9johnsone 75,633
10sonicefu 73,805
11markgeer 73,042
12YANN0S 68,787
13MikeOM_... 68,776
14awking00 68,665
15ishando 63,777

	[x] Attachment Details

PL/SQL cursor question

[x]

The Solution Rating System

With so many solutions, how can you tell which solutions are most likely to help you and which ones are not? To provide you with a tool to use, we rate our solutions based on various elements that most accurately determine if a solution is a quality solution. To explain what factors affect the solution rating, here are the elements we take into consideration when formulating our solution rating.

The Grade of the Solution
The Zone Rank of the Expert Providing the Solution
The Number of Author and Expert Comments
The Number of Experts Contributing
The Feedback of the Community

Your Input Matters
Because of the way the system is set up, the most important variable in this equation is you. As a member of Experts Exchange, you are able to cast your vote on the quality of the solutions in regard to how complete, accurate, helpful and easy to understand each solution is. When you provide your feedback, each rating is adjusted accordingly. So, if you see a solution that has a poor rating that you think is a good solution, let us know by rating it. As you do, the rating will be adjusted and will become more accurate for other members of our site.

If you have any suggestions that you would like to make for our rating system, please ask a question in the Suggestions Zone of Community Support.

Thank you!

7.6

Zones: PL / SQL, Oracle Database

Tags: cursor

I was wondering if anyone knows of a convenient way to compare data coming from two different cursors. Basically, I'm doing a procedure that tracks changes for data that never has done such, and then sending the changed data to another company.

The deal is that I have a cursor that extracts the actual data. I have another cursor that checks to see if the source data has been recorded and if it has, check for changes and mark it to be sent. Since there are multiple tables, I would like to have a "blackbox" routine that will compare the columns of two cursors and return whether or not the current rows are the same.

Confusing enough?

Here is what I have:

CURSOR other_cur (c_number NUMBER)
IS
SELECT * FROM tracking_table
WHERE id = c_number;

found_cur other_cur%ROWTYPE;

BEGIN
FOR cur IN (SELECT * FROM my_source@db_link) LOOP
OPEN other_cur ( cur.id );
FETCH other_cur INTO found_cur;
IF BlackBox( cur, found_cur ) THEN
-- mark record as changed in TRACKING_TABLE
END IF;
...
END;

For my BlackBox function, I want to be able to iterate through the columns of the supplied cursors and check to see if they are the same.

Any ideas folks? Open to other solutions, so if you have another idea, please let me know.

	#	Title
	1	How to fetch a cursor into an object?
	2	cursor_type emp%rowtype
	3	Retrieve data from an oracle packagein…
	4	How to iterate through rowtype columns
	5	Outputting a rowtype
	6	Problem when fetching data from ref c…