CREATE OR REPLACE PACKAGE "INTEHEL"."PARAM_PACKAGE" is
procedure set_param(startdate varchar2,enddate varchar2);
function get_startdate return varchar2;
function get_enddate return varchar2;
end ; 程序包创建成功CREATE OR REPLACE PACKAGE BODY "INTEHEL"."PARAM_PACKAGE" is
sdate varchar2,edate varchar2;
as
begin
procedure set_param(startdate varchar2,enddate varchar2) as
begin
sdate:=startdate;
edate:=enddate;
end set_param;
function get_startdate return varchar2 as return sdate; end get_startdate;
function get_enddate return varchar2 as return edate; end get_enddate;
end param_package ; 包体无效
大家帮忙看下哪儿错了
procedure set_param(startdate varchar2,enddate varchar2);
function get_startdate return varchar2;
function get_enddate return varchar2;
end ; 程序包创建成功CREATE OR REPLACE PACKAGE BODY "INTEHEL"."PARAM_PACKAGE" is
sdate varchar2,edate varchar2;
as
begin
procedure set_param(startdate varchar2,enddate varchar2) as
begin
sdate:=startdate;
edate:=enddate;
end set_param;
function get_startdate return varchar2 as return sdate; end get_startdate;
function get_enddate return varchar2 as return edate; end get_enddate;
end param_package ; 包体无效
大家帮忙看下哪儿错了
解决方案 »
- 问个oracle默认查询排序问题
- oracle10+3300磁盘阵列碰到的问题
- 索引覆盖问题
- 导入数据的时候报ora-03120错误,怎么解决?
- sqlserver syscolumns和sysobjects表 oracle对应是什么
- 请教:我用VC++连接ORACLE,为什么提示表名无效啊?
- PL/SQL过程中中嵌入HTML,为什么创建成功,却看不到页面?
- 高手请进,先谢过!
- 急急急!sqlldr导入问题
- 求助:高并发的java接口项目执行存储过程导致ActiveMq堵塞,数据源不可用数量超高,以及最终Weblogic的server状态被更改为Failed
- oracle rman 恢复后,重建临时表空间,是怎么一回事?
- Oracle查询的怪现象
--参考一下:CREATE OR REPLACE PACKAGE BODY "INTEHEL"."PARAM_PACKAGE" as procedure set_param(startdate varchar2, enddate varchar2) is
sdate varchar2(20);
edate varchar2(20);
begin
sdate := startdate;
edate := enddate;
end set_param; --以下注释掉了,以便调试。--function get_startdate return varchar2 as
--return sdate;
--end get_startdate; function get_enddate return varchar2 as
--return edate;
--end get_enddate;
end param_package;
procedure set_param(startdate varchar2,enddate varchar2);
function get_startdate return varchar2;
function get_enddate return varchar2;
end ;CREATE OR REPLACE PACKAGE BODY pkg_a is
sdate varchar2(200);
edate varchar2(200);
procedure set_param(startdate varchar2,enddate varchar2) as
begin
sdate:=startdate;
edate:=enddate;
end;
function get_startdate return varchar2 as begin return sdate; end;
function get_enddate return varchar2 as begin return edate; end; begin
sdate := '';
edate := '';
end pkg_a ;