--获得价格区间--
CREATE OR REPLACE function WANFO. fn_GetPriceArea ( v_dj number )
return varchar2
is
v_jgqj varchar2( 50);
SQL_GETPRICEAREA varchar2( 2000);
begin
SQL_GETPRICEAREA:='SELECT flag FROM JGQJB WHERE ZXJE <= ''' ||v_dj ||''' AND ZDJE > '''||v_dj|| ''' ';
execute immediate SQL_GETPRICEAREA into v_jgqj;--执行oracle 方法
if v_jgqj is null or v_jgqj ='' then ---判读返回值是否为空
begin
v_jgqj :=0;
end;
end if;
return v_jgqj;
exception
when others then dbms_output.put_line( 'error');
return -1 ;
end fn_GetPriceArea ;
/
