more info ~ I am using Toad 12.8 with 11.2 oracle client, rest of my colleague are using older toad version (11.6*) and they are able to get the results. any idea?
Is XMLTYPE involved at all? That could cause it, but 11.6 didn’t support XMLTYPE either.