Re: Oracle Text with Forms

From: steve_roach <steve_roach_at_hotmail.com>
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

Original text of this message