KB15974: 'Invalid SQL Statement' error occurs when an Oracle stored procedure is called in MicroStrategy Intelligence Server 10.x

SYMPTOM:
A user tries to execute an Oracle stored procedure within a report in Strategy 8.x via a pre/post statement or within a freeform SQL report using the following syntax:
 

EXEC ProcedureName

 
The following error occurs:
 

Error: SQL Generation Complete
QueryEngine encountered error: Execute Query failed. Error type: Odbc error. Odbc operation attempted: SQLExecDirect. ORA-00900: invalid SQL statement

 
Below is an example of using a pre/post statement VLDB property to call an stored procedure with the wrong format:
 

 
CAUSE:
The syntax used to run the procedure is incorrect.
 
ACTION:
Use CALL, not EXEC, in the SQL statement as seen below:  
 

{CALL ProcedureName}

 
Note: The aboe syntax in ODBC Test Tool should be enclosed within curly braces {} but when using it in Strategy Desktop VLDB Setting, it can be used without curly braces.
Below is an example of using a pre/post statement VLDB property to call an stored procedure with the correct format: