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
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