Symptoms
Handling Oracle cursors as a return type
Diagnoses
I am using a smartobject to execute a procedure inside a package. The procedure returns a cursor variable as an OUT parameter. The procedure executes successfully when ran by K2 but the return type on the smartobject is just one field of type Memo. How do I get K2 to return all of the columns in my cursor instead of a long XML string as the only output?
Resolution
This can be achieve by setting the Oracle service instance > 'Complex Output as XML' service key = false:
"When set to true, it means that REF CURSORS will return their data as a single property in XML format:"
"Compared to setting the flag to false and returning it as properties:"
As per:https://help.k2.com/onlinehelp/k2blackpearl/UserGuide/4.7/default.htm#ServiceBrokers/Oracle/Oracle.htm?Highlight="Complex Output as XML"