Compare values in each column of two Oracle Types

Posted by colinjameswebb on Stack Overflow See other posts from Stack Overflow or by colinjameswebb
Published on 2010-04-09T16:00:30Z Indexed on 2010/04/09 16:03 UTC
Read the original article Hit count: 269

Filed under:
|

I've been playing around with the pluto-test-framework today, and I'd like to get some existing functions into a test harness with it.

I have lots of functions with this type of specification.

   FUNCTION DO_SOME_STUFF   (pOldSchedule       IN      SCHEDULE_OBJ,
                             pNewSchedule          OUT  SCHEDULE_OBJ,
                             pLoggerContext     IN OUT  LOGGER_CONTEXT_OBJ)
   RETURN NUMBER;

It takes pOldSchedule, does some stuff to it, and then returns pNewSchedule. The logger_context just does logging.

As part of a test, I'd like to be able to compare the values in each of the columns of the type, without having to write individual IF statements.

It'll need to return boolean to signify whether or not pOldSchedule and pNewSchedule match.

Any ideas?

© Stack Overflow or respective owner

Related posts about Oracle

Related posts about plsql