Ora-01795

Collapse
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • praveenmittal
    New Member
    • Aug 2007
    • 4
    #1

    Ora-01795

    I have a application which extracts certain details and give me a report. Sometime, due to the large number of objects, the select query generated by the expression fails as the number of expression in 'IN' clause exceeds 1000.

    This is Oracle specific issue. I could see for the work-around in the net, but I can change anything in the application.

    Is there any limit in the Oracle which can be changed, so that it accepts more expression in 'IN' clause or Oracle has released any patch for it.

    Please provide your valuable suggestion.

    THanks

    Praveen
    Tags: ora-01795
    • amitpatel66
      Recognized Expert Top Contributor
      • Mar 2007
      • 2358
      #2
      Originally posted by praveenmittal
      I have a application which extracts certain details and give me a report. Sometime, due to the large number of objects, the select query generated by the expression fails as the number of expression in 'IN' clause exceeds 1000.

      This is Oracle specific issue. I could see for the work-around in the net, but I can change anything in the application.

      Is there any limit in the Oracle which can be changed, so that it accepts more expression in 'IN' clause or Oracle has released any patch for it.

      Please provide your valuable suggestion.

      THanks

      Praveen

      Make use of subquery instead of hard coded values in IN clause.

        Comment

        Previous template Next
        Working...