PL/SQL: ORA-00942 using Stored Procedure with DG4ODBC to MySQL after ODBC Driver upgrade (Doc ID 2606259.1)

Last updated on NOVEMBER 01, 2019

Applies to:

Symptoms

When using a Stored Procedure with a DG4ODBC connection to MySQL after upgrading the ODBC driver to
MySql ODBC Connector 8.0 you receive the following errors:

ERROR at line 7:
ORA-06550: line 7, column 11:
PL/SQL: ORA-00942: table or view does not exist
ORA-06550: line 4, column 9:
PL/SQL: SQL Statement ignored
ORA-06550: line 20, column 37:
PL/SQL: ORA-00942: table or view does not exist
ORA-06550: line 18, column 9:
PL/SQL: SQL Statement ignored
ORA-06550: line 29, column 37:
PL/SQL: ORA-00942: table or view does not exist
ORA-06550: line 27, column 9:
PL/SQL: SQL Statement ignored
ORA-06550: line 38, column 28:
PLS-00201: identifier '<IDENTIFIER>' must be declared
ORA-06550: line 38, column 13:
PL/SQL: Statement ignored
ORA-06550: line 40, column 88:
PLS-00364: loop index variable '<VARIABLE>' use is invalid
ORA-06550: line 40, column 16:
PL/SQL: Statement ignored

When performing a select statement via SQL*Plus, it is working fine.  The error occurs when using a Stored Procedure. 

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.