请教各位！急！很菜的问题

[goodhy]

我在PL程序块中给一个varchar2类型的变量赋值,内容是打开一个游标，请问怎么样让oracle去执行这个varchar2变量中的语句。
或者还有什么办法可以在存储过程里执行一个变量中的sql语句,或者ddl语句，等等

create or replace procedure DotNetPagination()
is
type t_cursor is ref cursor;
v_cur t_cursor;
Cstr varchar2(1000);
begin
Cstr := 'OPEN v_cur FOR select * from cd_dwdm';

execute immediate Cstr; --这句话出错。

end;

[qiaozhiwei]

试试这样行不行：
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; 放在包头里，或是个全局变量

[zhaokeke2004]

执行DDL:
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;

[goodhy]

to： qiaozhiwei(乔)
试了一下，不行

[juren250]

create or replace procedure DotNetPagination()
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;

[liuyi8903]

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;

[liuyi8903]

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;

[liuyi8903]

不好意思,多了对括号^_^
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;

[phant0m]

'OPEN v_cur FOR select * from cd_dwdm'这是sql的语法吧，oracle用is不用for

[goodhy]

我时时

[goodhy]

ok,liuyi8903(juventus) 说的正确的