试试这样行不行:
create or replace procedure DotNetPagination()
is
type t_cursor is ref cursor;
v_cur t_cursor;
Cstr varchar2(1000);
begin
Cstr := 'select * from cd_dwdm';
OPEN v_cur FOR Cstr ;end;
将 type t_cursor is ref cursor; 放在包头里,或是个全局变量
create or replace procedure DotNetPagination()
is
type t_cursor is ref cursor;
v_cur t_cursor;
Cstr varchar2(1000);
begin
Cstr := 'select * from cd_dwdm';
OPEN v_cur FOR Cstr ;end;
将 type t_cursor is ref cursor; 放在包头里,或是个全局变量
解决方案 »
- 关于数据库数据查询效率
- 求求求!! 一个关于数据库查询的问题
- 求写oraclesql向一张表循环插入数据,有测试数据
- 跨库数据更新问题
- oracle导出的dmp文件自动消失
- function中使用select 查找记录,结果为空时报错??
- 我用dblink把远程数据库的表复制到本地数据库,表的纪录有2000多万条,我直接在本地CREATE TABLE 总报TEMP表空间无法扩展,如何解决
- 查看表中字段的命令是什么?
- 急:关于错误ORA-01031
- 做etl还是dba啊,各位老哥大神帮我分析分析
- 找天津oracle application 高手
- 请问各位达人如何在Pl/sql中创建View??Create view不行啊!
create or replace procedure dsql1
is
begin
execute immediate 'create table test(name char(2))';
dbms_output.put_line('successful !');
exception
when others then
dbms_output.put_line('error !!!');
end;
试了一下,不行
is
type t_cursor is ref cursor;
v_cur t_cursor;
Cstr varchar2(1000);
begin
open v_cur for 'select * from cd_dwdm';
然后你可以对游标v_cur操作了
end;
is
type t_cursor is ref cursor;
v_cur t_cursor;
Cstr varchar2(1000);
begin
Cstr := ' select * from cd_dwdm'; execute immediate Cstr;
OPEN v_cur For cstr;
.
.
. end;
is
type t_cursor is ref cursor;
v_cur t_cursor;
Cstr varchar2(1000);
begin
Cstr := ' select * from cd_dwdm'; execute immediate Cstr;
OPEN v_cur For cstr; end DotNetPagination;
create or replace procedure DotNetPagination
is
type t_cursor is ref cursor;
v_cur t_cursor;
Cstr varchar2(1000);
begin
Cstr := ' select * from cd_dwdm'; execute immediate Cstr;
OPEN v_cur For cstr; end DotNetPagination;