我的代码如下: PACKAGE CCPTESTPACKAGE
IS type outlist is REF CURSOR;
Procedure CCPSelect(
maxrow in number,
minrow in number,
return_list out outlist
); END; -- Package spec
PACKAGE BODY CCPTESTPACKAGE
IS
PROCEDURE CCPSELECT
( maxrow in number,
minrow in number,
return_list out outlist)
IS
-- Enter the procedure variables here. As shown below
BEGIN
open return_list for
select * from testproc; END; -- Enter further code below as specified in the Package spec.
END;上述的代码将存储过程CCPSELECT写入了PACKAGE BODY里
我现在要将存储过程CCPSELECT写在PACKAGE BODY外如何实现??
IS type outlist is REF CURSOR;
Procedure CCPSelect(
maxrow in number,
minrow in number,
return_list out outlist
); END; -- Package spec
PACKAGE BODY CCPTESTPACKAGE
IS
PROCEDURE CCPSELECT
( maxrow in number,
minrow in number,
return_list out outlist)
IS
-- Enter the procedure variables here. As shown below
BEGIN
open return_list for
select * from testproc; END; -- Enter further code below as specified in the Package spec.
END;上述的代码将存储过程CCPSELECT写入了PACKAGE BODY里
我现在要将存储过程CCPSELECT写在PACKAGE BODY外如何实现??
解决方案 »
- varchar类型的字段,按数值计算的问题
- BIEE查询时偶尔返回空值,救命呀!
- 让我痛惜的ORACLE!!猇亭区中国一个行政区划地名,这个猇(xiao)字在ORCLE数据库表中没法保存。
- (20分)请问怎么给一个SQL视图增加一个ID字段并得到序号!
- ORA--06502的问题
- 如何将查询结果连接成字符串????
- Oracle 9.2.0.6下UTL_FILE文件读取超长问题
- 帮帮忙
- 天啦!Oracle怎么这么难用呀,要备份一个东西,说要在OMS方式下,用OMS这种方式进,怎么这进不去,救救我呀!高分请教
- oracle有数组变量,并且数组变量可以作为表的字段存在。请问如果一个字段是数组的话,在前端中应该如何处理呢
- sql server存储过程迁移到oracle上时出现的问题?
- 请各位帮我解释几个名词,谢谢!
( maxrow in number,
minrow in number,
return_list out outlist)
IS
-- Enter the procedure variables here. As shown below
BEGIN
open return_list for
select * from testproc; END CCPSELECT;
( maxrow in number,
minrow in number,
return_list out outlist)
IS
-- Enter the procedure variables here. As shown below
BEGIN
open return_list for
select * from testproc; END CCPSELECT;