Symptoms

We tried to use Oracle to return a result set, but ran into problems. I had no problem consuming a single scalar result from the same package.
 

Diagnoses

After some troubleshooting, we found that there was a bit of a bug with the Oracle service broker. When getting a result set back when using a Oracle "package", the smartobject tester tools stated that we should input the result set as an input as well, even thought the result set was declared as type "out" in the package
 

Resolution

This was a bug and a coldfix was provided.  Please contact K2 Support to obtain this coldfix.

The coldfix will mark the resultset  as "Out".   The result set was returned as XML.