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
Messages: 32
Registered: November 2007
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
Re: Compare Rcords [message #297518 is a reply to message #297452] Fri, 01 February 2008 04:00 Go to previous message
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.


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

Current Time: Sat Jul 22 06:24:53 CDT 2017

Total time taken to generate the page: 0.05892 seconds