Oracle过程问题!
(v_Condi IN NVARCHAR2,SWV_ref OUT SQLWays.ref_cur)
AS
v_sqlSt VARCHAR2(255);
BEGIN
if ltrim(rtrim(v_Condi)) = '' then
open SWV_ref for SELECT * from project WHERE ROWNUM <= 1;
ELSE
if SUBSTR(v_Condi,1,1) = '{' and SUBSTR(v_Condi,LENGTH(v_Condi),1) = '}' then
v_sqlSt := 'select * from project where ' || SUBSTR(v_Condi,'',LENGTH(v_Condi) -'');
EXECUTE IMMEDIATE v_sqlSt;
ELSE
--v_sqlSt:='select * from project where project like v_Condi';
--open SWV_ref for v_sqlSt;
open SWV_ref for select * from project where project like v_Condi;
END IF;
END IF;
END;
EXECUTE IMMEDIATE v_sqlSt;这样可以获取数据集吗?