create or replace testpor(v_nodeid number,recode_cursor out sys_refcursor) as v_sqlstr varchar2(4000); begin v_sqlstr:='select fybm from zf_fy where zf_fy.nodeid='||v_nodeid; open recode_cursor for v_sqlstr; end;
create or replace procedure testpor(v_nodeid number,recode_cursor out sys_refcursor) as v_sqlstr varchar2(4000); begin v_sqlstr:='select fybm from zf_fy where zf_fy.nodeid='||v_nodeid; open recode_cursor for v_sqlstr; end;
create or replace procedure testpor(v_nodeid number,recode_cursor out sys_refcursor) as v_sqlstr varchar2(4000); begin v_sqlstr:='select fybm from zf_fy where zf_fy.nodeid='''||v_nodeid||''''; open recode_cursor for v_sqlstr; end; 试试这样
create or replace procedure testpor(v_nodeid number,recode_cursor out sys_refcursor) as v_sqlstr varchar2(4000); begin v_sqlstr:='select JSBH from zf_js where zf_js.nodeid='||v_nodeid; open recode_cursor for v_sqlstr; end;
返回游标类型的 out参数
create or replace testpor(v_nodeid number,recode_cursor out sys_refcursor)
as
v_sqlstr varchar2(4000);
begin
v_sqlstr:='select fybm from zf_fy where zf_fy.nodeid='||v_nodeid;
open recode_cursor for v_sqlstr;
end;
as
v_sqlstr varchar2(4000);
begin
v_sqlstr:='select fybm from zf_fy where zf_fy.nodeid='||v_nodeid;
open recode_cursor for v_sqlstr;
end;
PLS-00306: 调用 'TESTPOR' 时参数个数或类型错误
ORA-06550: 第 1 行, 第 7 列:
PL/SQL: Statement ignored 什么意思?
as
v_sqlstr varchar2(4000);
begin
v_sqlstr:='select fybm from zf_fy where zf_fy.nodeid='''||v_nodeid||'''';
open recode_cursor for v_sqlstr;
end;
试试这样
as
v_sqlstr varchar2(4000);
begin
v_sqlstr:='select JSBH from zf_js where zf_js.nodeid='||v_nodeid;
open recode_cursor for v_sqlstr;
end;
带了么