oracle 错误（2,7）：PLS-00428：此 SELECT 语句中需要 INTO 子句
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/4710471/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me):
StackOverFlow
Error(2,7): PLS-00428: an INTO clause is expected in this SELECT statement
提问by andandandand
I'm trying to create this trigger and getting the following compiler errors:
我正在尝试创建此触发器并收到以下编译器错误：
create or replace
TRIGGER RESTAR_PLAZAS
AFTER INSERT ON PLAN_VUELO
BEGIN
SELECT F.NRO_VUELO, M.CAPACIDAD, M.CAPACIDAD - COALESCE((
SELECT count(*) FROM PLAN_VUELO P
WHERE P.NRO_VUELO = F.NRO_VUELO
), 0) as PLAZAS_DISPONIBLES
FROM VUELO F
INNER JOIN MODELO M ON M.ID = F.CODIGO_AVION;
END RESTAR_PLAZAS;
Error(2,7): PL/SQL: SQL Statement ignored
Error(8,5): PL/SQL: ORA-00933: SQL command not properly ended
Error(8,27): 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 delimited-identifier> <a bind variable> << close current delete fetch lock insert open rollback savepoint set sql execute commit forall merge pipe
Error(2,1): PLS-00428: an INTO clause is expected in this SELECT statement
What's wrong with this trigger?
这个触发器有什么问题？
回答by Gary Myers
You won't be allowed to
你将不被允许
SELECT count(*) FROM PLAN_VUELO
SELECT count(*) FROM PLAN_VUELO
in a trigger on PLAN_VUELO
在 PLAN_VUELO 的触发器中
Don't use a trigger. Use a stored procedure.
不要使用触发器。使用存储过程。
回答by fabiopagoti
Just add the into clause according to the result type, one example:
只需根据结果类型添加 into 子句即可，举个例子：
declare
my_result VUELO%rowtype;
begin
select v.* into my_result from VUELO v where id = '1';
end;
回答by Alex Poole
Inside a PL/SQL block you have to SELECT ... INTOsomething. I had an example of this in an answer to one of your questions yesterday. In this case you may want to select into a local variable, and use the result to then update another table.
在 PL/SQL 块中，您必须SELECT ... INTO有所作为。我昨天在回答你的一个问题时有一个例子。在这种情况下，您可能希望选择一个局部变量，然后使用结果更新另一个表。
But it looks like you're probably going to get lots of results back because you haven't restricted to the value you're interested in; the WHEREclauses don't filter on any of the inserted row's :NEWvalues. That will cause an ORA-02112. You need to make sure your select will return exactly one row, or look at cursors if you actually want multiple rows.
但看起来你可能会得到很多结果，因为你没有限制你感兴趣的值；这些WHERE子句不会过滤任何插入行的:NEW值。这将导致 ORA-02112。您需要确保您的选择将返回准确的一行，或者如果您确实需要多行，请查看游标。
