Did you check the instance alert log? What was the error number (i.e.
ORA-nnnnn: <text>)?
--
Ron Reidy
Oracle DBA
l.maestri_at_mimesi.com wrote:
> Hi everybody.
>
> I have a problem with a query using multiple instances of the
> "contains" operator.
> It's something like this: "select field1,field2 from table1 where
> contains(fieldx,'something1',1)>0 and
> contains(fieldx,'something2',2)>0"
>
> This query is executed from inside an EJB (WebSphere 3.5.4) through a
> thin connection.
> My Java code terminates with an exception on the executeQuery line:
> "End of TNS Data Channel". This exception is dued to an Oracle crash
> (core dump of Oracle 9i - 9.0.1.0.1 - ACCESS VIO).
>
> The same query with only ONE "contains" operator or executed through
> an OCI connection runs without errors.
>
> The Oracle Text indexed field is a BLOB field.
>
> Any ideas?
>
> Thanks for your help.
>
>
Received on Tue Feb 04 2003 - 06:22:43 CST
