Devart Forums

I have a table that has a COMMENTS VARCHAR2(100) field. When call SaveChanges() to save my changes to the entity, if I've changed the COMMENTS field then I get the following error ...

PLS-00201: identifier 'SYS.DBMS_LOB' must be declared

Any ideas? If I don't change that field then everything works fine.

1. Are there any triggers for your table in the database?
2. Turn on the dbMonitor tool to find out the exact SQL statement which leads to the error and specify this SQL:
http://www.devart.com/dotconnect/oracle ... nitor.html
http://www.devart.com/dbmonitor/dbmon3.exe
3. Please create a new table with VARCHAR2(100) column and add it to the model. Does the problem persist with the new table as well?
4. Try granting a privilege for your user:
GRANT EXECUTE ON SYS.DBMS_LOB TO <YOUR USER>
5. Are you using Code-First mapping or edmx/edml?