Re: Oracle Text with Forms
Date: 1 Jun 2006 05:20:23 -0700
Message-ID: <1149164423.172487.208150_at_i40g2000cwc.googlegroups.com>
Jeremy wrote:
> 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
Yeah, you're quite right, I just posted the fragment. The fact is, it is the 'CONTAINS' keyword that the parser is complaining about. As in...
...
AND CONTAINS(table.column, 'S%') > 0
...
[Quoted] [Quoted] By 'native', I mean SQL*PLUS and/or TOAD. If I drop the statement into either of those, I get the specced results.
I'm looking for a 'this can't be done noway', 'the workaround is', or even 'you idiot, the syntax is...' if anyone knows.
TIA Received on Thu Jun 01 2006 - 14:20:23 CEST