Home » SQL & PL/SQL » SQL & PL/SQL » Compare Rcords (10g and 9i, Unix)
Compare Rcords [message #297452] Thu, 31 January 2008 12:48 Go to next message
dasgupta.amitava@gmail
Messages: 32
Registered: November 2007
Member
Dear all,
I have two procedures proc-A and proc-B, both of them returns a cursor having 53 cols. I want to write another porc which will call these two proc with the same input parmeter and tally the outputs from both the cursors.
Now to do this I am thinking of creating an user defined record having all the fields that the cursor will return. Then declare two variables having datatypes same to the user defined record. Then compare their values field-by-field.
Is there any other way to acheive the same? I mean to say without referencing each and every field, can I compare two records?


Thanks in advance
Amitava..........
Re: Compare Rcords [message #297518 is a reply to message #297452] Fri, 01 February 2008 04:00 Go to previous message
S.Rajaram
Messages: 1027
Registered: October 2006
Location: United Kingdom
Senior Member
This may not be exactly what you want. But atleast it would give you an idea.
http://www.psoug.org/reference/dbms_rectifier_diff.html

Regards

Raj
Previous Topic: Need a small help in query
Next Topic: Database connections
Goto Forum:
  


Current Time: Fri Dec 09 07:58:30 CST 2016

Total time taken to generate the page: 0.14582 seconds