| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.server -> Re: context contains in procedure
Steve Donovan wrote:
>
> I have a context server and text search application
> but now I want to create some procedures to text search.
>
> For a simple example, if I were to use a query such as:
>
> select * from mytable
> where contains(text_col, 'me') > 0;
>
> everything works fine. However, stick that same query inside a procedure
> and it results in error:
Transparent query is not integrated with PL/SQL until version 8.1 For PL/SQL procedures, you should use two-step (ctx_query.contains) or IMQ (ctx_query.open_con), depending on your requirements. two-step generally has better throughput, IMQ better response.
Also, depending on your version, you might be able to use dbms_sql to do a contains query.
--
Garrett Kaminaga Oracle ConText Server Group ---------------------------------------------------------------------Note: remove underscores to get real email address Standard disclaimers apply -- all posts are personal opinion Received on Wed Nov 11 1998 - 14:45:56 CST
 |
 |