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

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for Oracle
Post Reply
msX
Posts: 7
Joined: Mon 02 Jun 2008 15:06

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

Post by msX » Mon 17 Nov 2008 17:42

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.

AndreyR
Devart Team
Posts: 2919
Joined: Mon 07 Jul 2008 13:16

Post by AndreyR » Thu 20 Nov 2008 15:27

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.

Post Reply