Home » Server Options » Text & interMedia » object CTXSYS.CONTAINS is invalid
object CTXSYS.CONTAINS is invalid [message #75995] Wed, 06 November 2002 19:56 Go to next message
George Lee
Messages: 1
Registered: November 2002
Junior Member

I tried to execute the Select Statement below in Oracle Forms, but I could not compile the Form.

select count(*) into :block3.item4 from docs where contains(test, 'first') > 0;
error message: object CTXSYS.CONTAINS is invalid

Is it possible to use CONTAINS in Oracle Forms?
This select statement works on SQL*Plus.

Thanks in advance!
oracle inter media [message #76016 is a reply to message #75995] Sun, 19 January 2003 02:29 Go to previous message
Messages: 1
Registered: January 2003
Junior Member
We are going to use oracle inter media packages in Designer 6i for searching in text,voice and videos.
but we can not use query with CTX.CONTAINS in designer 6i.
please reply us these two questions:
1. can we use inter media packages in designer 6i ?
2.Where can we find complete documents for oracle inter media (specially which are used in designer 6i)?
Previous Topic: Problem in querying using Contains Operator
Next Topic: Text Media error when using FILE_DATASTORE
Goto Forum:

Current Time: Wed Aug 23 03:09:18 CDT 2017

Total time taken to generate the page: 0.12405 seconds