遇到符号“文件结束”--plsql-Java 学习之路

执行后显示：

PACKAGE BODY TEMP_PACKAGE的编译错误

错误：PLS-00103：遇到以下其中一项时遇到符号“end-of-file”：begin end function pragma procedure Line：17

create or replace package body TEMP_PACKAGE is

procedure insert_temp
(aaCode number,aaName varchar2, aaAddress varchar2, 
 aaPhone varchar2, aaState varchar2 ) 

 is
 begin
 INSERT INTO temp_employee_azizbek
 (code, aadName, aadAddress, aadPhone, aadState )
 VALUES (aaCode, aaName,aaAddress,aaPhone,aaState);

 end;

我的错是什么？

1 回答

缺少额外的 end ，除了包 body 之外，还需要包 definition （ header ）：

create or replace package TEMP_PACKAGE is
 procedure insert_temp(aaCode number,aaName varchar2, aaAddress varchar2, 
                       aaPhone varchar2, aaState varchar2 );
end TEMP_PACKAGE;
/
create or replace package body TEMP_PACKAGE is

procedure insert_temp(aaCode number,aaName varchar2, aaAddress varchar2, 
                      aaPhone varchar2, aaState varchar2 ) is
begin
 INSERT INTO temp_employee_azizbek
 (code, aadName, aadAddress, aadPhone, aadState )
 VALUES (aaCode, aaName,aaAddress,aaPhone,aaState);
end;
end TEMP_PACKAGE;
/

回复于 2024-05-06T02:29:34+08:00

遇到符号“文件结束”--plsql

1 回答

相关问题