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: CLOB Index creation
Next Topic: How to ignore case in CLOB search?
Goto Forum:

Current Time: Mon Sep 21 06:48:20 CDT 2020