Hi,
I keep getting the error: ORA-06511: PL/SQL: cursor already open
when executing below, can someone please tell me why:-
DECLARE
info_ VARCHAR2(2000);
attr_ VARCHAR2(2000);
newrec_ identity_invoice_info%ROWTYPE;
automatic_pay_auth_flag_db VARCHAR2(1):= '1';
CURSOR get_supp IS
SELECT * FROM IDENTITY_INVOICE_INFO;
BEGINFOR rec_ IN get_supp LOOP
OPEN get_supp;
FETCH get_supp INTO rec_;
EXIT WHEN get_supp%NOTFOUND;
CLOSE get_supp;
Client_SYS.Clear_Attr(attr_);
Client_SYS.Add_To_Attr('AUTOMATIC_PAY_AUTH_FLAG_DB',automatic_pay_auth_flag_db,attr_);
IDENTITY_INVOICE_INFO_API.Modify__(info_,rec_.objid,rec_.objversion,attr_,'DO');
END LOOP;COMMIT;
END;