PLS-00306: wrong number or types of arguments in call to &am

building semantic layer
1

Hi,

I want to build an universe over stored procedure. However, I always met an error like below:
PLS-00306: wrong number or types of arguments in call to “”
screensho see

It’s saying that exception on row 1 column 8, but I cannot see why there’s error. It’s a pretty simple stored procedure:


create or replace procedure TestOneParameter(reportpar in varchar2, reportres  out Types.cursorType)
is
num1 number;
num2 number;
par1 varchar2(20);
par2 varchar2(20);
par3 varchar2(20);
begin
num1:=instr(reportpar,'@',1,1);
num2:=instr(reportpar,'@',1,2);
...

Please help. Thanks in advance.

Regards,
Otaku

sirotaku (BOB member since 2009-08-24)

2

issue solved. :mrgreen:

sirotaku (BOB member since 2009-08-24)

3

Hi sirotaku.

Can you tell me what was the solution?
I have the same problem.

Faro00 :poland: (BOB member since 2009-04-07)