Ora -01795
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Ora -01795

  1. #1
    Join Date
    Apr 2002
    Posts
    291

    Ora -01795

    Hi All,
    We are running with ORacle 9.0.1.4 on linux 7.2, One of our developer is trying to access a report from the application, and he got an error :

    oerr ORA 01795
    01795, 00000, "maximum number of expressions in a list is 1000". I know this is a bug in 8.0.5 but this was fixed in 8.1.6 onwards. Can any one please help me how to resolve this issue. Is this a bug still in 9.0.1.4.?

    Many thanks in advance
    PNRDBA

  2. #2
    Join Date
    Aug 2002
    Location
    Colorado Springs
    Posts
    5,253
    It's not a bug, it's a documented db limitation.

    Error message reads the same in 9.2, so i guess it's the same.
    David Aldridge,
    "The Oracle Sponge"

    Senior Manager, Business Intelligence Development
    XM Satellite Radio
    Washington, DC

    Oracle ACE

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width