Cannot access rows from a non-nested table item
Posted: Sun 11 Dec 2005 10:40
Hello,
in Oracle i use a function to create a piplined Table.
If i call this function with
Select * from Table(Create_Table1(1))
every thing works fine
but if i try to use it wit Parameter like
Select * from Table(Create_Table1(:v_param))
i get the following Error
"ORA-22905:cannot access rows from a non-nested table item"
What is wrong
Thanks for Help
Edgar
in Oracle i use a function to create a piplined Table.
If i call this function with
Select * from Table(Create_Table1(1))
every thing works fine
but if i try to use it wit Parameter like
Select * from Table(Create_Table1(:v_param))
i get the following Error

"ORA-22905:cannot access rows from a non-nested table item"
What is wrong
Thanks for Help
Edgar