call a function from report. [message #240016] |
Wed, 23 May 2007 22:04 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
nguyenthiphan
Messages: 2 Registered: May 2007
|
Junior Member |
|
|
I'm using Oracle10g in my job,
I created a function with pipelined keyword and parameter in.
When I called the function from report by select SQL or PL/SQL by pass direct parameter such as:
select * from table(tao_bckqdd('1-Mar-2007','%','%'));
--tao_bckqdd is name of function
everything seems ok.
But When i called the function from report by pass parameter by using user parameter of report I got error!!!!!!!
select * from table(tao_bckqdd(:ngaysl,:dkbc,:macn));
Error ORA-22905 cannot access rows from a non-nested table item.
Can everybody help me!!!!!!!!!!!!!!! to call a function from report.
Thanks so much.
|
|
|
Re: call a function from report. [message #240033 is a reply to message #240016] |
Thu, 24 May 2007 00:08 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/72104.gif) |
Littlefoot
Messages: 21818 Registered: June 2005 Location: Croatia, Europe
|
Senior Member Account Moderator |
|
|
This is what Oracle says:Quote: | 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
|
|
|
|