Page 1 of 1

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

Posted: Mon 12 Dec 2005 10:16
by Challenger
Please specify the script to create your server objects.