Cannot access rows from a non-nested table item

Discussion of open issues, suggestions and bugs regarding ODAC (Oracle Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
[email protected]
Posts: 6
Joined: Sun 11 Dec 2005 10:21

Cannot access rows from a non-nested table item

Post by [email protected] » 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

Challenger
Devart Team
Posts: 925
Joined: Thu 17 Nov 2005 10:53

Post by Challenger » Mon 12 Dec 2005 10:16

Please specify the script to create your server objects.

Post Reply