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:
Oracle Database - Enterprise Edition - Version 12.1.0.1 and laterInformation in this document applies to any platform.
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
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Symptoms |
Cause |
Solution |