What privalages do I need to access CTXSYS.CTX_DLL?

[spook007]

I might be going about this the wrong way, but I'm experimenting... I'm trying to automate the synchronization and optimization of my CONTEXT Indexes when ever a user makes an update on the field that is being indexed.

In order to do this, I've placed the following PL/SQL code in a trigger that is fired every time there is an update to the ARTICLE_DESCRIPTION field:

BEGIN
CTX_DLL.SYNC_INDEX('LUD.ARTICLE_DES_IDX' );
CTX_DLL.OPTIMIZE_INDEX('LUD.ARTICLE_DES_IDX', 'FULL');
END;

When I enable the trigger I get the following message:

PLS-00904: Insufficient privilage to access object CTXSYS.CTX_DLL
PL/SQL: Statement Ignored
PLS-00904: Insufficient privilage to access object CTXSYS.CTX_DLL
PL/SQL: Statement Ignored

What privalges do I have to enable in order for the trigger to work?

 

[raygg]

Try the DBA role.

 

[manvis]

Try ctxapp role.
or
grant execute on CTX_DLL to the user