oracle - plsql存储过程采用参数给出错误

我试图在pl/sql开发人员中创建一个过程，例如

create or replace procedure insert_muh_fis(birim_id in number(15)) is
begin
     insert into muh_Fis_d013
     select * from muh_fis mf where mf.fk_birim_id = birim_id;
     --delete from muh_fis mf where mf.fk_birim_id = birim_id;
     --commit;
end;

但这给了我编译错误。

Error: PLS-00103: Encountered the symbol "(" when expecting one of the following: := . ) , @ % öndeğer karakterThe symbol ":=" was substituted for "(" to continue.
Line: 1

任何想法都可以帮助我解决该问题，我将不胜感激。非常感谢你。

最佳答案

您无需在IN参数中指定数据类型的精度，您的参数声明应类似于birim_id IN NUMBER。

尝试，

CREATE OR REPLACE
PROCEDURE insert_muh_fis(birim_id IN NUMBER)
IS
BEGIN
     INSERT INTO muh_fis_d013
     SELECT * FROM muh_fis mf WHERE mf.fk_birim_id = birim_id;
     --delete from muh_fis mf where mf.fk_birim_id = birim_id;
     --commit;
END;

关于oracle - plsql存储过程采用参数给出错误，我们在Stack Overflow上找到一个类似的问题：https://stackoverflow.com/questions/20771023/

MF

oracle - plsql存储过程采用参数给出错误