SAP Knowledge Base Article - Preview

1205176 - Error: "Parse failed ORA-01797 "This operator must be followed by ANY or ALL"" when you create an object with an @prompt connecting to an Oracle database and try to parse the object.

Symptom

You create an object with an @prompt connecting to an Oracle database and you try to parse the object and you receive error "Parse failed ORA-01797 "This operator must be followed by ANY or ALL"".

This error may be reproduced in the Beach universe with an object with the following lines:

SELECT

BEACH.RESORT.RESORT

WHERE

BEACH.RESORT.RESORT= @Prompt('Please Select a Site Id','A','Beach Resort\Resort',multi,free)


Read more...

Product

SAP BusinessObjects Business Intelligence platform 5.1.8 ; SAP BusinessObjects Business Intelligence platform 5.1.9

Keywords

8202 , , KBA , BI-RA , Reporting, analysis, and dashboards , How To

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.