KB16822: 'Error: SQL Generation Complete QueryEngine encountered error ORA-06550: … identifier 'MY_PROCEDURE' must be declared …' error occurs when executing an Oracle stored procedure in a Freeform SQL report in MicroStrategy 9.x

SYMPTOM:
Users may execute a Freeform SQL report containing a call to an Oracle stored procedure, for example:
 
{call MY_PROCEDURE}
The following error message appears:
 
Error: SQL Generation Complete QueryEngine encountered error: Execute Query failed. Error type: Odbc error. Odbc operation attempted: SQLExecDirect. ORA-06550: line 1, column 8: PLS-00201: identifier 'MY_PROCEDURE' must be declared ORA-06550: line 1, column 8: PL/SQL: Statement ignored Error in Process method of Component: QueryEngineServer, Project Strategy Tutorial, Job 1653, Error Code= -2147212544.
CAUSE:
This error message appears when the stored procedure called does not exist within the local tablespace of the Freeform SQL report database instance.
 
ACTION:
The stored procedure should be defined within the local tablespace specified by the Freeform SQL report database instance, as shown below:
 

 
The following Strategy Knowledge Base technical note details the requirements for using Oracle stored procedures in Strategy:
 

• KB14959 : How to use stored procedures with Freeform SQL reports in Oracle or DB2 data warehouses in Strategy SQL Generation Engine 9.x