using ctx_ddl.drop_preference

I'm trying to use ctx_ddl.drop_preference pl/sql package, but getting error while compiling store procedure
"identifier 'CTX_DDL' must be declared"
Can someone explain how and where this package should be used.
I'm lloking at somebody's code and apparently the purpose of it is to convert LONG to CLOB.
Looks like the person is trying to create index for clob value.

smenaAsked:
Who is Participating?
 
ToddBarryConnect With a Mentor Commented:
In order to make a call to CTX_DDL in a stored procedure, CTXSYS will need to 'grant execute on ctx_ddl to username'.  This direct grant is required - the CTXAPP role is not sufficient.

http://osi.oracle.com/~tkyte/Misc/RolesAndProcedures.html
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.