Oracle Solution for Error ora-37141

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

What triggered the Error:

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

What should we do to fix it:

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).