Hello Guru!
I wanted to know if accessing a pipelined table function from a view is ok.
I have created a view that calls a table function in the following way.
create or replace force view hoppin_view(location, phone_number) AS
Select location, phone_number from table(hoppin_view_function));
It compiles and seems fine. It also has the following dependencies
- hoppin_view_function
- hoppin_type
The function compiles and is happy.
In the package I call upon it and everything seems fine, I place the results in a local defined holder.
The issues is when I try and access the contents of the local holder, it seem I cannot.
Thanks!