gpt4 book ai didi

sql - PLS-00103 : Encountered the symbol "end-of-file" in simple update block

转载 作者:行者123 更新时间:2023-12-04 14:11:11 24 4
gpt4 key购买 nike

以下 Oracle 语句:

 DECLARE ID NUMBER;
BEGIN
UPDATE myusername.terrainMap
SET playerID = :playerID,tileLayout = :tileLayout
WHERE ID = :ID
END;

给了我以下错误:
ORA-06550: line 6, column 15:
PL/SQL: ORA-00933: SQL command not properly ended
ORA-06550: line 3, column 19:
PL/SQL: SQL Statement ignored
ORA-06550: line 6, column 18:
PLS-00103: Encountered the symbol "end-of-file" when expecting one of the following:

( begin case declare end exception exit for goto if loop mod
null pragma raise return select update while with
<an identifier> <a double-quoted>

我几乎不知所措。这似乎是一个相当简单的陈述。如果有帮助的话,我有一个类似的语句,它执行了一个曾经可以工作的 INSERT,但今天给了我同样的信息。

最佳答案

where id=:id 后面加一个分号

关于sql - PLS-00103 : Encountered the symbol "end-of-file" in simple update block,我们在Stack Overflow上找到一个类似的问题: https://stackoverflow.com/questions/3056410/

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