谢谢 lishuogang兄,我改成以下声明,编译通过。CREATE OR REPLACE PROCEDURE "AOSTAREIP"."RULEEXPORTSYS" (sVersion in varchar2) as ssVersion varchar2(200); begin select version into ssVersion from S_ModelSystem where (Version>=sVersion); end; 但是这样以来岂不是查询出来的所有记录的version字段内容全部都存入ssVersion变量了,是怎么存储的呢?
CREATE OR REPLACE PACKAGE pkg_test AS TYPE myrctype IS REF CURSOR; END pkg_test; /CREATE OR REPLACE PROCEDURE "AOSTAREIP"."RULEEXPORTSYS" (sVersion in varchar2,p_rc out pkg_test.myrctype) as ssVersion varchar2(50); begin ssVersion:='select version from S_ModelSystem where Version>='''||sVersion||''''; open p_rc for ssVersion; end;
http://expert.csdn.net/Expert/topic/1512/1512119.xml?temp=.3453638
(sVersion in varchar2)
as
ssVersion varchar2(200);
begin
select version into ssVersion from S_ModelSystem where (Version>=sVersion);
end; 但是这样以来岂不是查询出来的所有记录的version字段内容全部都存入ssVersion变量了,是怎么存储的呢?
AS
TYPE myrctype IS REF CURSOR;
END pkg_test;
/CREATE OR REPLACE PROCEDURE "AOSTAREIP"."RULEEXPORTSYS"
(sVersion in varchar2,p_rc out pkg_test.myrctype)
as
ssVersion varchar2(50);
begin
ssVersion:='select version from S_ModelSystem where Version>='''||sVersion||'''';
open p_rc for ssVersion;
end;