PL/SQL (MOSC)

MOSC Banner

Getting ora-01031 insufficient privileges when using clob in PL/SQL code.

in PL/SQL (MOSC) 6 commentsAnswered

We have all needed grants. The SQL used executes and returns rows. No views are used. We can execute all functions, procedures, and packages.  We have never seen this error before in other projects before this instance. We are for the first time using CLOB. We are using CLOB for dynamic SQL. If we use a VARCHAR2 the OPEN cursor executes and returns rows, 6 rows in out test case. We have one SQL statement that we are using now that is 7K characters including space long. We foresee long SQL stmts. 

Below is a test script we are using that returns the error.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center