Getting PLS-00382 while creating a table function
I created a type audit_exception_type and audit_exception_type1 as table of audit_exception_typeBelow code shows error PLS-00382create or replace function audit_exception_fn(begin_date number, end_date number)return audit_exception_type1 pipelined as cur_year number;other_year number;cursor temp_cur isselect * from mfs_admin.audit_exception where request_date >=trunc(to_date(end_date,'YYYYMMDD')) and request_date <trunc(to_date(begin_date,'YYYYMMDD')) and rownum<5;beginfor cur_rec in temp_cur looppipe row(cur_rec);end loop;end;end;/
0