错误:ORA-06553:PLS-306:呼叫过程中的参数数字或类型错误

Question

当我调用该过程时，它给了我错误：

ORA-06553: PLS-306: wrong number or types of arguments in call to 'UPDATE_LETTER_BODY'

这是我的过程代码：

    CREATE OR REPLACE PROCEDURE FMIS3.UPDATE_LETTER_BODY IS
    body_text varchar2(32767); 
    condition_id integer;
    begin    
        update FMS_K_OFFICEWISE_LETTER set FKOL_LETTER_BODY=body_text 
        where FKOL_OFFICEWISE_LETTER_ID=condition_id;
    end;

这是我打电话给它的方式：

     CALL UPDATE_LETTER_BODY('test',241);

Answer 1

检查一下：

       CREATE OR REPLACE PROCEDURE FMIS3.UPDATE_LETTER_BODY  ( body_text IN FMS_K_OFFICEWISE_LETTER.FKOL_LETTER_BODY%type,condition_id in FMS_K_OFFICEWISE_LETTER.FKOL_OFFICEWISE_LETTER_ID%type)IS
       begin
          update FMS_K_OFFICEWISE_LETTER set FKOL_LETTER_BODY= body_text
          where FKOL_OFFICEWISE_LETTER_ID=condition_id;
       end;     

Answer 2

应该是

CREATE OR REPLACE PROCEDURE FMIS3.UPDATE_LETTER_BODY(body_text in varchar2,condition_id in number) IS
begin    
    update FMS_K_OFFICEWISE_LETTER set FKOL_LETTER_BODY=body_text 
    where FKOL_OFFICEWISE_LETTER_ID=condition_id;
end;

Answer 3

CREATE OR REPLACE PROCEDURE FMIS3.UPDATE_LETTER_BODY  ( body_text  IN varchar2,condition_id  in integer ) IS
begin    
    update FMS_K_OFFICEWISE_LETTER set FKOL_LETTER_BODY=body_text 
    where FKOL_OFFICEWISE_LETTER_ID=condition_id;
end;

更新您的proc如上...