ORA-00920: - Row count error - invalid relational operator on trying do row count in IDT

Philip O'Rourke Jun 1, 2012 12:08 PM

Currently Being Moderated

Hi,

Using IDT and inserted new table into data foundation layer.

When try and insert new object, get the message ORA-00920 invalid relational operator.

Get this when try do row count on table.

Can run queries on this table in database no problem.

Other tables fine.

Any ideas?

Thanks

Re: ORA-00920: - Row count error - invalid relational operator on trying do row count in IDT

Philip O'Rourke Jun 1, 2012 5:17 PM (in response to Philip O'Rourke)

Currently Being Moderated

Discovered was due to bad join on table even though just doing a row count.
Report Abuse

Like (0)
- Re: ORA-00920: - Row count error - invalid relational operator on trying do row count in IDT
  
  Laxminarayana Kidambi Jun 4, 2012 4:34 PM (in response to Philip O'Rourke)
  
  Currently Being Moderated
  
  Hello Philip,
  
  Download the tracing tool Statement Tracer for Oracle (from downloads) from below site
  
  www.aboves.com
  
  This query tool will help you trace the query going back from the designer. It is not an official product from SAP.
  
  Regards,
  Laxminarayana
  
  Report Abuse
  
  Like (0)
  - Re: ORA-00920: - Row count error - invalid relational operator on trying do row count in IDT
    
    Philip O'Rourke Jun 4, 2012 6:55 PM (in response to Laxminarayana Kidambi)
    
    Currently Being Moderated
    
    Hi Laxminarayana,
    
    This looks a useful tool.
    
    Thanks
    
    Report Abuse
    
    Like (0)