Re: HOW TO: Create a trigger for ctxsys.context?

jimi_xyz_at_hotmail.com wrote:
> I think i posted in the wrong group before, or maybe no one wants to
> answer my question..
>
> I have 5 colummns that are indexed using ctxsys.context. When a user
> adds some more information to one of these columns; the columns need to
> automatically re-index themselves. Not to sure how to accomplish this
> and example or web page would be very help full.
>
> Thank you,
> Jimi
>

Read up on context indexes - do they need reindexing? Some do, some don't.
The version of your RDBMS is important in this case!

Assuming 10g or the latest 9.2, your trigger can submit a job that does the sync (not reindex!) of your index.

-- 
Regards,
Frank van Bortel

Top-posting is one way to shut me up...