plsql中关于包的问题!求解释
create or replace package wan123
is
procedure jiayou(
firstnumber number,
secondnumber number,
jieguo out number);
end wan123;
create or replace package body wan123
is
procedure jiayou(
firstnumber number,
secondnumber number,
jieguo out number)
is
begin
jieguo=firstnumber+secondnumber;
end;
以上是创建的一个包,为甚总是显示Encountered the symbol "CREATE" 错误
------解决方案----------------------package
create or replace package wan123
is
procedure jiayou(
firstnumber number,
secondnumber number,
jieguo out number);
end wan123;
--package body
create or replace package body wan123
is
procedure jiayou(
firstnumber number,
secondnumber number,
jieguo out number)
is
begin
jieguo:=firstnumber+secondnumber;
end;
end wan123;
------解决方案--------------------包头和包体分开来创建的
------解决方案--------------------你以什么用户创建的,默认的包就在这个用户下面
------解决方案--------------------包头和包体之间加上斜杠。
------解决方案--------------------人家1楼不写给你了吗,当人家不存在呀
jieguo=firstnumber+secondnumber;
错在这,应是赋值:=而不是=
jieguo:=firstnumber+secondnumber;