"PLS-00307: Too Many Declarations of 'PARSE' Match This Call" error After Upgrade

(Doc ID 1232114.1)

Last updated on JULY 05, 2017

Applies to:

PL/SQL - Version 11.1.0.6 and later
Information in this document applies to any platform.
***Checked for relevance on 21-Jun-2013***

Symptoms

Executing code related to DBMS_SQL.PARSE that worked in the 9i and/or 10g Database now fails with the following error after upgrading to version 11.1 or higher database.

PLS-00307: too many declarations of 'PARSE' match this call


declare
   v_cursor NUMBER := DBMS_SQL.OPEN_CURSOR;
   v_sql VARCHAR2(100) := 'SELECT * FROM DEPT';
   v_mode VARCHAR2(40) := DBMS_SQL.NATIVE;
begin
   DBMS_SQL.PARSE(c=> v_cursor, statement=> v_sql, language_flag=> v_mode);
end;
/

ERROR at line 6:
ORA-06550: line 6, column 2:
PLS-00307: too many declarations of 'PARSE' match this call
ORA-06550: line 6, column 2:
PL/SQL: Statement ignored



Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms