-- FUNCTION: hsggjyk_dev.getnewsinfo(numeric, character varying, numeric, numeric, refcursor)
-- DROP FUNCTION hsggjyk_dev.getnewsinfo(numeric, character varying, numeric, numeric, refcursor);
CREATE OR REPLACE FUNCTION hsggjyk_dev.getnewsinfo(
plx numeric,
pdq character varying,
ym numeric,
myhs numeric,
INOUT pcursor refcursor,
OUT retval refcursor)
RETURNS record
LANGUAGE 'edbspl'
COST 100.0
VOLATILE NOT LEAKPROOF
AS $function$
v_StartIndex number;
v_EndIndext number;
begin
v_StartIndex:=(YM-1)*MYHS+1; --分页开始行
v_EndIndext:=YM*MYHS; --分页结束行
if pLX is not null then
open pCURSOR for
select ID,BT,FMLJ,XWLJ,GJZ,FBSJ,ZYCD from (
select rownum as rown,ID,BT,FMLJ,XWLJ,GJZ,FBSJ,ZYCD
from "hsggjyk_dev"."newsinfo"
where lx=pLX and nvl(dq,'111')=coalesce(pDQ,dq,'111') and rownum<=v_EndIndext) where rown>=v_StartIndex;
end if;
end
$function$;
ALTER FUNCTION hsggjyk_dev.getnewsinfo(numeric, character varying, numeric, numeric, refcursor)
OWNER TO ggjy_mg_usr;