Home  >  Article  >  Database  >  Oracle存储过程中PLS-00103:出现符号“/”在需要下列之一时:(

Oracle存储过程中PLS-00103:出现符号“/”在需要下列之一时:(

WBOY
WBOYOriginal
2016-06-07 17:29:083037browse

Oracle存储过程中mdash;mdash;PLS-00103:出现符号ldquo;/rdquo;在需要下列之一时:(

Oracle中编写一存储过程:出现如下错误,

PLS-00103:出现符号“/”在需要下列之一时:(

经过各种谷歌百度,在存储过程中定义变量不允许使用关键字,而我定义了变量sum,导致错误。

经过编译后的过程代码为:

create or replace procedure avg_sal(result out char)
is 
i number(5);
summ number(20); 
countnum number(20);
begin 
 i:=10;
 while i  i:= i+10; 
  select sum(salary),count(*) into summ countnum from emp where deptno=i; 
  result:=summ/countnum;
 end loop;
end;
/

linux

Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn