关于 ORA-22905: cannot access rows from a non-nested table item

关于 ORA-22905: cannot access rows from a non-nested table item

• 博客分类： 
• 数据库

Access 

在写存储过程的时候 
假如 
function a  is return Type 
Type 是某种类型 
通过 
open cursor for select * from table (function a) 就会报 ora-22905的错 
分析原因 

引用

ORA-22905: cannot access rows from a non-nested table item 
Cause: attempt to access rows of an item whose type is not known at parse time or that is not of a nested table type 
Action: use CAST to cast the item to a nested table type

因此 你需要 cast一下，我试过 在 10g里面不需要，但是 9i就必须转换哈 
open cursor for select * from table ( cast(function a as type)) 这样就ok