|
|
|
|
|
|
| Author |
Message |
steve_roach
*nix forums beginner
Joined: 10 Oct 2005
Posts: 4
|
 Posted: Thu Jun 01, 2006 2:05 pm Post subject:
Re: Oracle Text with Forms
|
|
|
Cris Carampa wrote:
| Quote: | steve_roach wrote:
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.
A possible workaround could be to create a view that include the
CONTAINS clause and to call that view from Forms.
HTH. Kind regards,
--
Cris Carampa (spamto:cris119@operamail.com)
potevo chiedere come si chiama il vostro cane
il mio è un po' di tempo che si chiama Libero
|
Thanks for that Cris, it works fine - a good solution.
Shame, really, that the forms parser isn't up to speed. I suppose
Oracle will fix that some time. |
|
| Back to top |
|
 |
Cris Carampa
*nix forums Guru Wannabe
Joined: 06 May 2005
Posts: 122
|
| Posted: Thu Jun 01, 2006 12:25 pm Post subject:
Re: Oracle Text with Forms
|
|
|
steve_roach wrote:
| Quote: | 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.
|
A possible workaround could be to create a view that include the
CONTAINS clause and to call that view from Forms.
HTH. Kind regards,
--
Cris Carampa (spamto:cris119@operamail.com)
potevo chiedere come si chiama il vostro cane
il mio è un po' di tempo che si chiama Libero |
|
| Back to top |
|
|
steve_roach
*nix forums beginner
Joined: 10 Oct 2005
Posts: 4
|
| Posted: Thu Jun 01, 2006 12:20 pm Post subject:
Re: Oracle Text with Forms
|
|
|
Jeremy wrote:
| Quote: | In article <1149161645.737750.126260@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
....
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 |
|
| Back to top |
|
|
Jeremy
*nix forums Guru Wannabe
Joined: 26 Apr 2005
Posts: 228
|
| Posted: Thu Jun 01, 2006 11:55 am Post subject:
Re: Oracle Text with Forms
|
|
|
In article <1149161645.737750.126260@j55g2000cwa.googlegroups.com>,
steve_roach says...
| Quote: | 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 |
|
| Back to top |
|
|
steve_roach
*nix forums beginner
Joined: 10 Oct 2005
Posts: 4
|
| Posted: Thu Jun 01, 2006 11:34 am Post subject:
Oracle Text with Forms
|
|
|
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.
Does anyone know how to use Text Search in a Form or if there is a
workaround for this?
TIA
Steve |
|
| Back to top |
|
|
Google
|
|
| Back to top |
|
|
|
|
The time now is Fri Jan 09, 2009 4:58 am | All times are GMT
|
|
Live mortgage rates | Car Loan | Buy Anything On eBay | Credit Cards | Mobile Phones
|
|
Copyright © 2004-2005 DeniX Solutions SRL
|
|
|
|
Other DeniX Solutions sites:
Unix/Linux blog |
electronics forum |
medicine forum |
science forum |
|
|
Privacy Policy
|
Powered by phpBB © 2001, 2005 phpBB Group
|
|
FAQ
Search
Memberlist
Usergroups
Register
Profile
Log in to check your private messages
Log in
Forum index
»
Databases
»
Oracle
»
Tools
