Forum Stats

  • 3,875,898 Users
  • 2,266,987 Discussions
  • 7,912,374 Comments

Discussions

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

doberkofler
doberkofler Member Posts: 43 Blue Ribbon

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;

/

Tagged:

Answers