Re: Oracle Text with Forms

[Quoted] In article <1149161645.737750.126260_at_j55g2000cwa.googlegroups.com>, steve_roach says...
> Hi,
>
> I'm not sure this can be done but can't find a reference in the docs.
>
> I am building a Form (v6.0.8.11.3) on Oracle 9i and my WHEN BUTTON
> PRESSED trigger includes this in a select statement:
>
> CONTAINS(table.column, 'S%')
>
> When compiling, I get:
>
> Error 707 at line 1, Column 10
> Unsupported construct or internal error [2603]
>
> This works fine in native SQL. I can only think that there is a lag in
> the Forms SQL parser. Or something.

I thought you had to code it as

contains(col,text) > 0

Contains is a function which returns a number?

Does it really work in "native sql"?

-- 

jeremy