Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

using ctx_ddl.drop_preference

Posted on 2004-09-21
3
Medium Priority
?
1,877 Views
Last Modified: 2007-12-19
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.

0
Comment
Question by:smena
1 Comment
 
LVL 3

Accepted Solution

by:
ToddBarry earned 500 total points
ID: 12117957
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

Featured Post

NFR key for Veeam Backup for Microsoft Office 365

Veeam is happy to provide a free NFR license (for 1 year, up to 10 users). This license allows for the non‑production use of Veeam Backup for Microsoft Office 365 in your home lab without any feature limitations.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article started out as an Experts-Exchange question, which then grew into a quick tip to go along with an IOUG presentation for the Collaborate confernce and then later grew again into a full blown article with expanded functionality and legacy…
This post first appeared at Oracleinaction  (http://oracleinaction.com/undo-and-redo-in-oracle/)by Anju Garg (Myself). I  will demonstrate that undo for DML’s is stored both in undo tablespace and online redo logs. Then, we will analyze the reaso…
Via a live example show how to connect to RMAN, make basic configuration settings changes and then take a backup of a demo database
This video shows information on the Oracle Data Dictionary, starting with the Oracle documentation, explaining the different types of Data Dictionary views available by group and permissions as well as giving examples on how to retrieve data from th…
Suggested Courses

580 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question