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

[m sowjanya]

Hi
i am getting this error message when the following script is running

execute sp_GetTrialInfo();

 
create or replace procedure sp_GetTrialInfo
  (
 
    parStudy_Name OUT  mivrs_studyinfo.study_name %type,
    parContact_Name OUT mivrs_studyinfo.contact_name %type,
    parPhone_Number OUT mivrs_studyinfo.phone_number %type,
    parDescription OUT mivrs_studyinfo.description %type
  )
  AS
  BEGIN
    SELECT study_name,contact_name,phone_number,description
    INTO
           parstudy_name,parcontact_name,parphone_number,pardescription
    FROM mivrs_studyinfo;
 
END sp_GetTrialInfo;
 
 

[amitpatel66]

Becuase you ar einvoking a procedure that has four OUT parameters without mentioning the parameter names to which the values will be returned by the procedure.

You have to do something like:

declare
study_name mivrs_studyinfo.study_name%type;
c_name mivrs_studyinfo.contact_name%type;
v_ph mivrs_studyinfo.phone_number%type;
v_desc mivrs_studyinfo.description%type;
BEGIN
sp_GetTrialInfo(study_name,c_name,v_ph,v_Desc);
DBMS_OUTPUT.PUT_LINE(study_name||','||c_name||','||v_ph||','||v_Desc);
END;
/