SYS.DBMS_LOB must be declared

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for Oracle
Post Reply
worthingtonjg
Posts: 1
Joined: Thu 22 May 2014 20:28

SYS.DBMS_LOB must be declared

Post by worthingtonjg » Thu 22 May 2014 20:33

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.

Shalex
Site Admin
Posts: 9543
Joined: Thu 14 Aug 2008 12:44

Re: SYS.DBMS_LOB must be declared

Post by Shalex » Mon 26 May 2014 11:35

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?

Post Reply