Hi, I'm trying to create a test pipelined table function. In the first declaration then i am receiving the following error:
"Identifier LOADER.SD_DIM_DATE must be declared."
How do I create a type based on an existing object, ie a table or cursor?
create type tDateDim AS table of LOADER.SD_DIM_DATE%ROWTYPE;
/
create or replace function tvf_DateDimm
return LOADER.SD_DIM_DATE%ROWTYPE pipelined is
begin
FOR i in (select * from LOADER.SD_DIM_DATE) loop
pipe row(I.REPORT_MONTH, I.REPORT_MONTH_DESC)
end loop;
return;
end;