How crazy is the search? I've done some ones with NS_CONCAT that put a bunch of data into one column result, and sometimes it would work and sometimes it wouldn't, turns out there is a limit on what can come back in the results. Limit is 4000 ASCII characters, but only about 1300 Unicode characters. This a natural limitation because of Oracle's maximum length of 4000 bytes for a VARCHAR data type.