pl/sql creating a function with parameterized cursor with return date
- by user3134365
create or replace
FUNCTION get_next_sch_date(cert_id VARCHAR2,test_id VARCHAR2)
RETURN DATE
AS
CURSOR next_sch_date(pb_id number,test_no varchar2)
IS
SELECT Sch_Controls,PBY_FRQ,START_AFTER__CAL_DAYS,PBY_DUE_BY,PBY_NEXT_SCH_TEST_DATE FROM
ms_cmp_plan_pby WHERE pby_id=pb_id AND test_plan_id=test_no;
l_new_date…
