Oracle Text with Forms
From: steve_roach <steve_roach_at_hotmail.com>
Date: 1 Jun 2006 04:34:05 -0700
Message-ID: <1149161645.737750.126260_at_j55g2000cwa.googlegroups.com>
Hi,
Date: 1 Jun 2006 04:34:05 -0700
Message-ID: <1149161645.737750.126260_at_j55g2000cwa.googlegroups.com>
Hi,
[Quoted] 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.
Does anyone know how to use Text Search in a Form or if there is a workaround for this?
TIA Steve Received on Thu Jun 01 2006 - 13:34:05 CEST