4 Replies Latest reply on Jul 7, 2020 7:00 AM by Peter2_1

    [19.4] Missing line-number in long SQLstatements

    Peter2_1

      I have a rather long SQL-statement because of creating temporary tables, using WITH.

       

      Approx. at line number 2000 I have my SELECT /JOIN / WHERE clause.

       

      When executing with errors, I get this message:

       

       

      ORA-00904: "LEIPU_TO"."LP_DESIG": invalid identifier
      00904. 00000 -  "%s: invalid identifier"
      *Cause:    
      *Action:
      

       

      When I set 1900 lines of my statement to "-- Comment", I have the same message.

       

      When I delete the 1900 lines and my SELECT / JOIN / WHERE goes up to approx. line number 120, the I get this message:

      ORA-00904: "LEIPU_TO"."LP_DESIG": invalid identifier
      00904. 00000 -  "%s: invalid identifier"
      *Cause:    
      *Action:
      Error at Line: 129 Column: 5
      
      

       

      You see - "Error at Line ...." is not displayed on long statements.

      Why?