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

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

Postby 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.
msX
 
Posts: 7
Joined: Mon 02 Jun 2008 15:06

Postby 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.
AndreyR
Devart Team
 
Posts: 2919
Joined: Mon 07 Jul 2008 13:16


Return to dotConnect for Oracle