gpt4 book ai didi

oracle - 错误 (7,1) : PLS-00103: Encountered the symbol "BEGIN"

转载 作者:行者123 更新时间:2023-12-05 08:16:35 37 4
gpt4 key购买 nike

我是一个新的 PL/SQL 用户。我尝试创建一个过程并像这样运行它:

create or replace procedure addp1(i in number) is

begin
insert into t3 values (i,'xxxx');
end addp1;

begin
addp1(99);
end;

但是我的日志文件中出现了error: Error(7,1): PLS-00103: Encountered the symbol "BEGIN"。谁能帮我解决这个问题。谢谢

最佳答案

create or replace procedure addp1(i in number) 
is
begin
insert into t3 values (i,'xxxx');
end addp1;
/* We have to actually push the block to the engine by issuing a '/' */
/

begin
addp1(99);
end;
/* Every PL/SQL Block needs this! */
/

关于oracle - 错误 (7,1) : PLS-00103: Encountered the symbol "BEGIN",我们在Stack Overflow上找到一个类似的问题: https://stackoverflow.com/questions/25426827/

37 4 0
Copyright 2021 - 2024 cfsdn All Rights Reserved 蜀ICP备2022000587号
广告合作:1813099741@qq.com 6ren.com