Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Using ConText contains() in subquery

Using ConText contains() in subquery

From: Marc Schabb <mschabb_at_home.com>
Date: Sat, 13 Nov 1999 19:09:13 GMT
Message-ID: <382DB730.B75241AE@home.com>

In the code below, the contains() function call fails with an "invalid column" error message. But if you comment out the first line and run the select statement as a top-level query, it works perfectly. We're building the (much more complicated) select statement dynamically, so redoing this as a stored procedure would be awkward. Any ideas?

insert into search_results (catalog_entry_id, score) SELECT catalog_entry.catalog_entry_id,
((score(10) * 5) + (score(30) * 2) + (score(20) * 1)) FROM catalog_entry
WHERE

(  contains(catalog_entry.title,             'pigskin', 10) > 0
or contains(catalog_entry.short_description, 'pigskin', 30) > 0
or contains(catalog_entry.long_description,  'pigskin', 20) > 0
)

  Marc Schabb
  Foundry
  410-223-2760 x3016 Received on Sat Nov 13 1999 - 13:09:13 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US