ora-22286 message
MunishMay 4 2012 — edited May 5 2012Hi,
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