 |
|
| > |
QUESTION POSED ON: 26 May 2004
I get an insufficient privileges message ("ORA-01031: insufficient privileges") when attempting an insert on a table with a CLOB column. When inserting a value using SQL*Plus, it works fine. When setting CLOB column to null it works fine too. But when inserting a bigger CLOB through an application, I get an error. My suspicion is the insert with a CLOB may have some privilege constraint depending on its size. Is there such privilege in Oracle?
|
|
| > |
EXPERT RESPONSE
Your problem is not related to the size of the CLOB value. There is no
object or system privilege that let's you insert small CLOB values but
stops you from inserting larger CLOB values. Rather, it is more likely
that your application connects as a different user than you did with
SQL*Plus. The application connection does not have the appropriate
privileges to be inserting anything to the CLOB column of the table.
|
|
|
|
|
|
|
|
Search and Browse the Expert Answer Center
Search and browse more than 25,000 question and
answer pairs from more than 250 TechTarget industry experts.
|
|
|
|
|
|
|
|
|
|
|
|
