SQLSTR:='SELECT SUPPLIER_NO,SUPPLIER_NAME,COMPANY_NAME,COUNTRY_NO,BUSINESS_PHONE,CREATED_DATE,IS_ENABLE FROM BA_SUPPLIER_NP '|| CONDITION||' ORDER BY CREATED_DATE DESC'; OPEN RETURNCUR FOR to_char(SQLSTR);
SQLSTR:='SELECT SUPPLIER_NO,SUPPLIER_NAME,COMPANY_NAME,COUNTRY_NO,BUSINESS_PHONE,CREATED_DATE,IS_ENABLE FROM BA_SUPPLIER_NP '|| CONDITION||' ORDER BY CREATED_DATE DESC'; OPEN RETURNCUR FOR to_char(SQLSTR);