PL/SQL (MOSC)

MOSC Banner

Getting PLS-00382 while creating a table function

edited Mar 13, 2013 10:56AM in PL/SQL (MOSC) 5 commentsAnswered
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;begin

for cur_rec in temp_cur looppipe row(cur_rec);end loop;end;end;/

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center