Oracle Error ORA-37141: (XSSQLMDQ01) Invalid host variable syntax for MDQUERY procedure.

Oracle Error Message

ORA-37141: (XSSQLMDQ01) Invalid host variable syntax for MDQUERY procedure.

Reason for the Error

The schema and analytic workspace name for the MDQUERY cursor declaration were incorrectly specified.

Solution

Specify the schema and awname as a host variable name preceded by a colon, or as a text literal string of the form ‘SCHEMA.AWNAME’ or ‘*.*’ (quotes optional).