I’m doing some research on different possibilities for unit testing in PL/SQL. I setup a little test database to do some testing. I have a custom object called ‘obj_customer’ which contains information about a customer. I have 2 functions which use this custom object. 1 function which gives back a collection of these custom objects and another function which gives back a ref cursor containing these custom objects.
I wrote unit tests for the function which returns a collection. This worked without any problems. But now I want to write tests for the function which gives back the ref cursor containing the custom objects. I have seen that you can count the elements of the ref cursor, this doesn’t work also. But is it possible to test custom objects in a ref cursor? Because I didn’t find an option for it or I must have overlooked it.
Thanks in advance
Message was edited by: NielsC