[plsql] Forum Topics

string query = "DECLARE l_cursor SYS_REFCURSOR;ServiceName la_service_provider_detail.service_name%TYPE;Surname people.surname%TYPE;Forename people.forename%Type;"+ "Action Varchar(50);Rate ey_pupil_premium_log.rate%Type;"+ "Funding_Code single_funding_formulas.funding_code%Type;"+ "BEGIN EYPupilPremiumPackage.GetEyPupilPremiumLog(pLogId=> 6613, pPreview => 'T',EyPupilPremiumLog=> l_cursor);"+ "LOOP"+ "FETCH :l_cursor "+ "INTO ServiceName, Surname, Forename,Action,Rate,Funding_Code;"+ /*IF l_cursor%NOTFOUND"+ Then DBMS_OUTPUT.PUT_lINE('NO DATA FOUND'); EXIT WHEN l_cursor%NOTFOUND; END IF; "END LOOP;"+ "DBMS_OUTPUT.PUT_LINE(ServiceName || ' | ' || Surname || …