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

[former_member272336]

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

[former_member272336]

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

[Former Member]

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

[former_member272336]

Hi Laxminarayana,

This looks a useful tool.

Thanks