Hello guys. I try add fee for supplier by PL/SQL functions. But i get some errors and i dont know where is the problem. DECLARE info_ VARCHAR2(32000) := NULL; attr_ VARCHAR2(32000); p1_ VARCHAR2(32000) := ''; p2_ VARCHAR2(32000) := ''; a_ NUMBER := 0; CURSOR get_data IS select p.SUPPLIER_ID from SUPPLIER_INFO_GENERAL p WHERE SUPPLIER_ID = '20040'; BEGINFOR rec_ IN get_data LOOP Client_Sys.Clear_Attr(attr_); Client_Sys.Add_To_Attr('VENDOR_NO', rec_.supplier_id, attr_); Client_Sys.Add_To_Attr('CONTRACT', 'RETIA', attr_); Client_Sys.Add_To_Attr('CHARGE_TYPE', 'DOPR + BAL', attr_); Client_Sys.Add_To_Attr('CHARGE_BY_SUPPLIER', rec_.supplier_id, attr_); IFSAPP.PURCHASE_CHARGE_SUPPLIER_API.NEW__(info_,p1_,p2_,attr_ ,'DO'); a_ := a_ + 1; END LOOP;END; ERROR what i get is
Already have an account? Login
No account yet? Create an account
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.
Sorry, our virus scanner detected that this file isn't safe to download.