Page 1 of 1

ORA-01795: Maximum Number of Expressions in a List is 1000

Posted: Mon 17 Nov 2008 17:42
by msX
During creation of a new EDM (->Add new element -> ADO.NET Entity Data Model -> Create from Database -> Next-> Choose Data Objects), I'll get the error message

"System.Data.Entity.CommandExecutionException" - "ORA-01795: Maximum Number of Expressions in a List is 1000".

This error occures only in version 5 - the latest 4.x version didn't show this issue.

Posted: Thu 20 Nov 2008 15:27
by AndreyR
Thank you for the report. The fix of this problem will be avilable in the next build of dotConnect for Oracle.
The problem is probably associated with the great quantity of DB objects the user has permission to access and roles user is included into.
As a temporary workaround, try to reduce the permissions and roles amount for this user or create a new one, with less roles and object grants.