title: wrong number or types of arguments in call to my procedure
body: <p>hi I wrote this code to create a procedure to return a Boolean value based on the if conditions but when I execute it I got this error:</p>
  
  <pre><code>ORA-06550: line 1, column 7:
  PLS-00306: wrong number or types of arguments in call to 'DDPAY_SP'
  ORA-06550: line 1, column 7:
  PL/SQL: Statement ignored
  06550. 00000 -  "line %s, column %s:\n%s"
  *Cause:    Usually a PL/SQL compilation error.
  *Action:
  </code></pre>
  
  <p>here is my procedure </p>
  
  <pre><code>create or replace procedure  DDPAY_SP (
  
  donor_id dd_donor.iddonor%type,
  pldgstatus out dd_pledge.idstatus%type,
  monthplan  out dd_pledge.paymonths%type,
  ret out boolean)
  IS
  begin
  
  select idstatus, paymonths into
  pldgstatus, monthplan from dd_pledge 
  where iddonor = donor_id ;
  
  if (pldgstatus = 10 AND monthplan &gt;0)
  then ret:= true;
  else
  ret:= false;
  end if;
  
  end;
  </code></pre>
  
  <p>and this how I execute it </p>
  
  <pre><code> EXECUTE DDPAY_SP (308);
  </code></pre>
  
  <p>I didn't put much talk I hope it's clear enough for you </p>
  
  <p>I read online it recommends me to check the naming also the data type which I did but nothing change </p>
  
  <p>any ideas </p>