create or replace package body 存储过程编译时总报错
来者 2013-12-19 03:54:38 create or replace package body PKG_GD_STUDENTINFO is
procedure MP_EL_INFORM is
begin
declare
v_update_sql varchar2(1000) := '';
end;
end MP_EL_INFORM;
end PKG_GD_STUDENTINFO;
=========================================================================
以上代码在PLSQL里面编译后总提示以下错误:
Compilation errors for PACKAGE BODY NEWSTUDENT.PKG_GD_STUDENTINFO
Error: PLS-00103: 出现符号 "END"在需要下列之一时:
begin function package
pragma procedure subtype type use <an identifier>
<a double-quoted delimited-identifier> form current cursor
Line: 16
Text: end;
Error: Hint: Variable 'v_update_sql' is declared but never used in 'MP_EL_INFORM'
Line: 15
Text: v_update_sql varchar2(1000) := '';