Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ora-22286 message

MunishMay 4 2012 — edited May 5 2012
Hi,
I am running 8.1.7 db.
I created a directory called IMAGES.
I created synonym for it .

I have a stored proc which when called post the images in the IMAGES directory to the db.

I am getting the following message and I am not sure what privilege am I missing. I believe I gave the user all the priv except any GLOBAL priv.

Here is the error message I get.

ORA-22286: INSUFFICIENT PRIVILEGES ON FILE OR DIRECTORY TO PERFORM GETLENGTH OPERATION
ORA-06512:AT "SYS.DBMS_LOB", LINE 578
ORA-06512: AT "EDUMET.POS

Thanks
Munish
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 2 2012
Added on May 4 2012
5 comments
2,876 views