你需要写到一个包中:
create or replace package pag_cs_power as type c_Type is ref cursor;
FUNCTION FUN_CS_GETDICTLIST(
v_DictIndex in varchar2) return c_Type;end pag_cs_power;存储过程代码:FUNCTION FUN_CS_GETDICTLIST(
v_DictIndex in varchar2) return c_Type
as
c_cursor c_Type;
begin
open c_cursor for
select DICTID,DICTNAME FROM SYS_DICT WHERE DICTINDEX = v_DictIndex;
return c_cursor;
end FUN_CS_GETDICTLIST;
create or replace package pag_cs_power as type c_Type is ref cursor;
FUNCTION FUN_CS_GETDICTLIST(
v_DictIndex in varchar2) return c_Type;end pag_cs_power;存储过程代码:FUNCTION FUN_CS_GETDICTLIST(
v_DictIndex in varchar2) return c_Type
as
c_cursor c_Type;
begin
open c_cursor for
select DICTID,DICTNAME FROM SYS_DICT WHERE DICTINDEX = v_DictIndex;
return c_cursor;
end FUN_CS_GETDICTLIST;
解决方案 »
- Oracle Database 11g Express Edition
- 新手请教kettle db链接问题
- oracle降序,去重,取前10条记录如何实现
- 一个Oracle查询问题!
- sqf%rowcount 到底可以使用几次,如下边的格式,oracle 知道是哪个sql%rowcount 吗 请高手指点
- oracle客户端与服务器端字符集不一致,修改客户端,服务器启动失败
- oracle 如何查看已经创建好的触发器语句
- Oracle逻辑结构理解问题
- ORACLE中,如何提高SQL的INSERT和DELETE的效率
- 小虫在redhat 7.3下装oracle 8i的问题,各位高手请进!
- JDK For Linux
- 数据库不可更改
create procedure get_count(recordcount out number)
as
sql:varchar2;
begin
sql:='select count(*) from yourtablename';
execute immediate sql into recordcount;
end;