SELECT TO_NUMBER(F_SYS_GETSEQID('SEQ_TERMTRADE_ID', V_PROVINCE_CODE)) INTO V_BATCH_ID FROM DUAL;
EXECUTE IMMEDIATE的说明:执行动态的sql语句。
下面贴上自己的一段 function 的用发 create or replace FUNCTION GET_LASTPRICE ( customID IN VARCHAR2 , materialID IN VARCHAR2 , unitid IN VARCHAR2 , currencyid IN VARCHAR2 , saleOrgID IN VARCHAR2 ) RETURN NUMBER AS
v_lastprice T_SCM_PricePolicyEntry.fprice%TYPE ; strsql varchar2(4000); BEGIN select price into v_lastprice from (select entrys.fprice as price from T_SCM_PricePolicyEntry entrys join T_SCM_PricePolicy bill on entrys.fparentid=bill.fid where bill.fsaleorgunitid=saleOrgID and entrys.fmaterialid =materialID and entrys.fcustomerid =customID and entrys.fcurrencyid=currencyid and entrys.fmeasureunitid=unitid and entrys.fcheckedstatus = 2 order by entrys.feffectivedate desc) where rownum=1; RETURN v_lastprice; END GET_LASTPRICE;