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

Question

我试图在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

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

Answer 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;