Skip to Main Content

ORDS, SODA & JSON in the Database

After upgrading from 22.2.1 to 22.3.2 I see "PLS-00306: wrong number or types of arguments" errors

doberkoflerNov 2 2022 — edited Nov 2 2022

After upgrading from 22.2.1 to 22.3.2 I see new "PLS-00306: wrong number or types of arguments" errors in a PL/SQL Gateway application using overloaded procedures.
Just reverting back to 22.2.1 without any other changes make the errors disappear, so I guess it must be something within the upgrade that causes the error.
The error is consistent in 22.3.2 and can be replicated at will.
Invoking v1 with two parameters can be used to replicate the problem:
CREATE OR REPLACE PROCEDURE v1(p1 IN VARCHAR2, p2 IN NUMBER)
IS
BEGIN
htp.prn('v1(p1,p2)');
END;
/
CREATE OR REPLACE PROCEDURE v1(p1 IN VARCHAR2, p2 IN NUMBER, p3 IN VARCHAR2)
IS
BEGIN
htp.prn('v1(p1,p2,p3)');
END;
/

Comments
Post Details
Added on Nov 2 2022
10 comments
130 views